There is no data. I just need the SQL query.

Scenario: Elite Video is a startup company providing concierge DVD kiosk service in Kennesaw, GA. FIGURE P8.47 THE CH08_MOVIECO ERD DETAILRENTAL MEMBERSHIP PK MEM NUM RENTAL RENT NUM PK,FK1 RENT NUM PK,FK2 VID NUM RENT_DATE FK1 MEM_NUM MEM_FNAME MEM_LNAME MEM_STREET MEM_CITY MEM_STATE MEM_ZIP MEM_BALANCE DETAIL_FEE DETAIL_DUEDATE DETAIL_RETURNDATE DETAIL_DAILYLATEFEE MOVIE PK MOVIE NUM VIDEO VID NUM PK PRICE PK PRICE CODE VID INDATE FK1 MOVIE_NUM - 0--- PRICE_DESCRIPTION PRICE_RENTFEE PRICE_DAILYLATEFEE MOVIE_TITLE MOVIE_YEAR MOVIE COST MOVIE GENRE FK1 PRICE_CODE 21) What was the total cost of all movies with a price code of 1 ? (w3schools -> SQL Function Count, Avg, Sum and SQL Where) 22) What was the total cost of rental fees charged for movies due on March 4, 2018. Change the output label to Fees_March4 (w3schools -> SQL Function Count, Avg Sum and SQL Where and SQL Alias). 23) What was the total cost Elite Video spent on all movies of each genre? (w3schools -> SQL Function Count, Avg Sum and SQL Group By). 24) How many movies of each genre does Elite Video have? (w3schools -> SQL Function Count, Avg Sum and SQL Group By). 25) For what genre of movies was the sum of the cost for the movies for that genre greater than $100? (w3schools -> SQL Function Count, Avg Sum and SQL Having). THIS ONE REQUIRES THOUGHT