Question: Hi , could someone please help me with this SQL Lite excercise? 1 . a ) Write the SQL using the subquery method to find
Hi could someone please help me with this SQL Lite excercise?
a Write the SQL using the subquery method to find the MediaType name with the lowest total purchase value and the total number of purchases. The total purchase value is the sum of the UnitPrice times Quantity of the invoice line item in the invoice items table for the media type. Round the total purchase value to decimals Note: You may need multiple subqueries
b Use the SQL in a write the SQL that will only display the Media Type Name column only.
The image with the table with columns are the expected output columns for question
Use the SQL subquery method to show the total number of customers with a total purchase value greater than the total purchase value of Puja SrivastavaNote: You can put a subquery as a field in the main select statement You are given the name and not the customerId. Submit the SQL and the resulting table.
The image with the table with columns are the expected output columns for question
Thank you very much :)
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
