Additional Query for Task 6

/*Query 11 -Actors with more than 20 credits to their name*/
SELECT COUNT(*) as 'Number of Actors with More than 20 Credits' FROM(SELECT peopleid FROM CREDITS WHERE credits.credited_as="A" GROUP BY credits.peopleid HAVING COUNT(*)>20);