SQL commands needed

runTime, movie (id, title, relYear, category, director, studioName, description, rating) actor (aID, fName, surname, gender) stars (movieID, actorID) movGenre (movieID, genre) (d) Using a subquery method list the title and category of movies that star the actor Michael Fassbender'. (5) (e) Find the movie(s) (listing the title and rating) with the highest rating. (5) (1) Using the implicit join syntax, list the title and release year of all movies which were directed by Angelina Jolie or which star Angelina Jolie as an actor. (5) (g) For each genre, list the genre and the number of movies in the database, released since 2000, for that genre. (5) (h) List the names of actors who have starred in more than 10 movies. (5) PTO