Q1 = '''SELECT PID AS actor_id, COUNT(role) AS no_of_movies
        FROM Cast
        GROUP BY PID'''
        
Q2 = '''SELECT year, COUNT(id) AS count
        FROM Movie
        GROUP BY year'''

Q3 = '''SELECT year, AVG(rank) AS avg_rank
        FROM Movie
        GROUP BY year
        HAVING COUNT(id) >= 10
        ORDER BY year DESC'''

Q4 = '''SELECT year, MAX(rank) AS max_rank
        FROM Movie
        GROUP BY year'''

Q5 = '''SELECT rank, COUNT(id) AS no_of_movies
        FROM Movie
        WHERE name LIKE 'a%'
        GROUP BY rank'''