Too many sub-queries, that I am already confused and I am still missing one column - Oracle
===

I have the following query that has no errors:

    SELECT u.user_name, u.user_lastn, outer_s.movie_id, outer_s.times_rented
    from users u,
    ( select * from  (   
        select user_id, movie_id, count (movie_id) as times_rented
          from movie_queue 
          group by (user_id, movie_id)
          order by user_id, movie_id 
        ) inner_s
    where times_rented>1
    ) outer_s
    
    where u.user_id= outer_s.user_id;

<br/>
This is what it returns:

    USER_NAME                USER_LASTN                 MOVIE_ID TIMES_RENTED
    ------------------------ ------------------------ ---------- ------------
    John                     Smith                             1            3 
    John                     Smith                             6            2 
    Mary                     Berman                            4            2 
    Mary                     Berman                            6            4 
    Elizabeth                Johnson                           1            2 
    Peter                    Quigley                           2            2 

<br/>
What I still need to do is to show the name of the movie, instead of the movie_id, but
the name of the movies are located in another table named movies that is similar to the
following sample:

     MOVIE_ID MOVIE_NAME                                                                                                                       
    ---------- ---------------------------------------------
             1 E.T. the Extra-Terrestrial    
             2 Jurassic Park                
             3 Indiana Jones and the Kingdom of the Crystal                
             4 War of the Worlds  
             5 Signs  

**Desired result:**
What I want to see in the final table are the following columns:<br/>
**USER_NAME**  |  **USER_LASTN**  |   **MOVIE_NAME** |  **TIMES_RENTED**  |


**Question:**
But after all the many subqueries I am very confused, how can I get the movie_name there instead of the movie_id?


**Attempted:**
I tried getting the desired result by changing the query to <br/>
<br/>

    SELECT u.user_name, u.user_lastn, m.movie_name, outer_s.times_rented
    from users u, movie m (etc.....)


But It returned 120 rows instead of the 6 I should get.

Help please!! 

