sample-three

Column "Movie Title" format a35;

select "Movie Title"
from  (select tm.MovieTitle as "Movie Title",
              count(tad.MovieID) as "Total Awards"
        from tblMovie tm 
              inner join tblAwardDetail tad on tm.MovieID = tad.MovieID 
        where tad.AwardResultID = '1' 
        group by tm.MovieTitle
        order by "Total Awards" desc) 
where ROWNUM = 1;

/*
Movie Title
-----------------------------------
Saving Private Ryan
*/