Write 4 queries with different subqueries

SELECT first_name 'First Name, surname 'Last Name', m.title 'Movie', m.year_released-born 'Age at release' FROM people p
LEFT JOIN
(SELECT * FROM movies m
INNER JOIN credits
ON m.movieid = c.movieid
WHERE p.born < m.year_released) c
ON c.peopleid = p.peopleid
WHERE c.credited_as = 'A'
ORDER BY m.year_released-born asc;

SELECT title 'Movie', first_name 'First Name', surname 'Last Name' FROM people
LEFT JOIN
(SELECT * FROM credits
INNER JOIN movies USING(movieid)
WHERE credited_as = 'A')
USING(peopleid)
WHERE country = 'fr'
ORDER BY surname desc;

SELECT m.title 'Main Title', a.title 'Alt Title', year_released 'Released in' FROM movies m
LEFT JOIN
(SELECT * FROM alt_titles
WHERE LENGTH(title) > 2) a
ON m.title = a.title
WHERE country = 'gb'
ORDER BY m.title;

SELECT title FROM movies
WHERE movieid IN
(SELECT movieid FROM credits
INNER JOIN people USING(peopleid)
WHERE died - born < 30)
ORDER BY title;

/*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);