SQL: Netflix would like to recognize and reward its most active members. Next month, Netflix is willing to lower its monthly payment for DVD plans for its most active members. Produce a query that shows all customers who rated movies at least 1,000 times. The query (presented in this exact order) must show: customer ID, first and last name (with a space between first and last), the total number of ratings they have made, DVD plan id they subscribe to, the customers current price per month (with dollar sign), and the new price per month (with dollar sign). Customers who rated at least 1,000 times will receive 5% off their monthly fee, customers who rated at least 5,000 times will receive 10% off of their monthly fee, and customers who rated at least 10,000 times will receive 25% off of their monthly fee. All calculations must be rounded to two decimal places. The number of ratings should be shown with commas to separate numbers as conventional (such as displaying 123,456). The query must be ordered with the most active customer at the top. This question is limited to dvdplans only

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