Question

I am trying to solve two SQL questions:

1. Display each movie’s title and total gross, where total gross is USA gross and worldwide gross combined. Exclude any movies that do not have values for either USA gross or worldwide gross. Show the highest grossing movies first.

2. Display the number of movies with an MPAA rating of G, PG, PG-13, and R. Show the results in alphabetical order by MPAA rating.

Answer 1

1.

Select Film_Title, (Worldwide_Gross+USA_Gross) as TOTAL_GROSS From Movies where (Worldwide_Gross IS NOT NULL) AND (USA_Gross IS NOT NULL) ORDER BY TOTAL_GROSS DESC;

2.

SELECT COUNT(FILM_TITLE) FROM movies WHERE MPAA_RATING IN ('G', 'PG', 'PG-13', 'R') ;

Do ask if any doubt. Please upvote.