Could you help me please? I have a table List:
List( cinema char (15) movie char (20))
I need to get movies which are shown in most cinemas and the number of times they are shown. If there are more then one movie shown the same number of times, there must be all of them.
All I wrote yet is:
SELECT MAX(CNT.cout) as maximum FROM (SELECT movie, COUNT(ALL cinema) as cout FROM List GROUP BY movie) as CNT
but it just shows the number of times the most shown move was showned...
Edited by yohgurt