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
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