Menu

List All Media Types And The Total Quantity Of Each Media Type. Order The Results In DESCENDING Order Of Quantities. (6 Points) 3. Find The Names Of All The Members Who Have NEVER Subscribe Any Membership. Assume That All The Records Of Subscriptions Are Kept Even After Expiration. (6 Points) 4. List The ID Of All The Media And How Many Times They Are

 

q5-q10 please

student submitted image, transcription available below

 

Expert Answer

Step 1

Sure, I’ll provide SQL queries for the tasks from Q5 to Q10:

5. Get the total revenue from the subscr…

OR