SQL question Netflix wants to find out the most popular movi

SQL question: Netflix wants to find out the most popular movies for teenagers and young adults. A recent research finding indicates that “PG”, “PG13”, and “R” rated movies with any form of the word “life” in the title are the most popular. Netflix requests a query that will display the titles, ratings, and release year of these popular movies. Netflix wishes to see the movies generated by your query in a chronologically reverse order. The latest movie should be at the top.

Hint: Your where clause may be very long because you need to meet all conditions of potential “life” combinations.

MOVIES A CTORS ACTORS MOVIES DIRECTORS MOVIES FORMAT MOVI EID NUMBER ACTO RID NUMBER (8 OV NUMBER MOVIEID NUMBER ACTORID NUMBER (6 AFNAME VARCHAR2 (25 DIRECTORID CHAR (8 FORMATID AL NAME VARCHAR2 35 MOVIES ACTORS K (MOVI EID ACTORID MOVIES DIRECTORS P MOVIEID, DIRECTORID MOVIES ORMAT FK (MOVI EID ORMAT TID BIRTH DATE DATE MOVIES ACTORS CON (MOVIEIDE MOVIES DIRECTORS FK (MOVIEID RMAT (FORMATID) GENDER MovIES MOVIES ACTORS CON (ACTO RID DIRECTORS FK2 (DIRECTORID EID ACTOR PK (ACTORID MOVIES ORMAT ORMATID CHAR FORMA DESCRIPT VARCHAR2 25 RMAT PK ORMATID MOVIES AWARDS PK (MOVIEID, AVARDID) PK MOVIES (MOVIEID) DIRECTORS K (DIRECTORID MOVIES AWARDS K (M OV MOVIES AWARDS K2 (AWARDID MOVIES GENRES MOVI EID NUMBER (.0 GENRE CODE RATINGS 100 CUSTOMERS MOVIES GENRES K (MOVI EID. GENRE CODE AWARDS MOVIEID NUMBER (.00 CUST CHAR (16) K GENRE S-MOVIES GENRES (GENRECODE) AVARDID RATING NUMBER CFNAME VARCHAR2 26 FK MovIE Mov E-GENRES (MOVIEID) AVIARD TITLE VARCHAR2 00 RDATE DATE CLNAME VARCHAR2 (50 CUST CHAR AWARDS K (ANIARDID VARCHAR2 (50 RATINOID NUMBER (10) C PASSWORD VARCHAR2 RATINGS 100-P RATIN GID) BIRTH MONTH NUMBER 2) GENRES BIRTH DAY NUMBER 2) USTID GENI VARCHAR2 3) REDITTYPI VARCHAR2 FK RATING Movies (MovIEID) STRIMPLANID CHAR (A) GENRENAME VARCHAR2 e5 NUMB VARCHAR2 DESCRIPTION VARCHAR2 00) CREDIT NAME VARCHAR2 75 GENRES GENRECODE PRICEPERMONTH NUMBER (5,2) CREDIT EXPIMTH NUMBER 02) ADDRESSES G PLAN-P K (STRM PLANID) REDITI NUMBER CUST ANKROUTING VARCHAR2 ADDRTYPE BANKACCOUNT VARCHAR2 (26 STREET ADDR VARCHAR2 (50) BANKHOLDER VARCHAR2 76 STREET ADDR2 VARCHAR2 (50) DRIVER VARCHAR2 25 CITY VARCHAR2 135) STATE CHAR DVD PLAN STATE CHAR (2) NUMBKIDS NUMBER 2) DVDPLANID CHAR (5 CHAR (5) PHONE NUMB CHAR DESCRIPTION VARCHAR2 00 STRMPLA NID CHAR (A) PK ADDRESSES (CUST DORTYP PRIC EPERMONTH NUMBER (5.2 DVD PLANID CHAR (5) FK ADDRESS USTOMER (CUST ID) DVD PLAN P DVDPLANID PK CUSTOMER (CUSTID) CUSTOMER S CON (STRM PLAN ID) CusTOMER S-CON2 (DVDFLA NID

Solution

select TITLE, MPAA_RATING, RYEAR
FROM MOVIES
WHERE
AND MPAA_RATING IN (\'PG\',\'PG13\',\'R\')
AND TITLE like \'%life%\'
order by TITLE desc,RYEAR;