Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a list of customers, sorted by lastname, firstname, that shows the total dollar amount that has been invoiced to each customer. Display the Lastname,
Create a list of customers, sorted by lastname, firstname, that shows the total dollar amount that has been invoiced to each customer. Display the Lastname, Firstname, and InvoicedAmount. (assume you are running on a computer where all commands and objects are case insensitive) Select one: a. Select LastName, FirstName, sum(Unit Price * Quantity) as InvoicedAmount From customers C, invoices I, invoice_items T Where C.Customerid = I.Customerid Group By LastName, FirstName Order By LastName, FirstName; b. Select LastName, FirstName, sum(Unit Price) as InvoicedAmount From customers C, invoices I, invoice_items T Where C.Customerid = I.Customerid and I.Invoiceid = T.Invoiceid Group By LastName, FirstName Order By Lastname, Firstname; c. Select LastName, FirstName, sum(UnitPrice * Quantity) as InvoicedAmount From customers C, invoices I, invoice_items T Where C.Customerid = I.Customerid and I.Invoiceid = T.Invoiceid Group By LastName, FirstName Order By LastName, FirstName; d. Select LastName, FirstName, sum(UnitPrice) as InvoicedAmount From customers C, invoices I, invoice_items T Where C.Customerid = I.Customerid and I.Invoiceid = T.Invoiceid Group By LastName, FirstName; e. Select LastName, FirstName, sum(Unit Price * Quantity) as InvoicedAmount From customers C Join Invoices 1 On C.Customerid = I.Customerid SSQLITE playlists Playlistid INTEGER Name NVARCHAR(120) TUTORIAL playlist_track Playlistid. INTEGER 9 Trackld. INTEGER media_types MediaTypeld. INTEGER Name: NVARCHAR(120) genres Genreld: INTEGER Name NVARCHAR(120) tracks Trackld. INTEGER Name NVARCHAR(200) Albumld. INTEGER MediaTypeld. INTEGER Genreld INTEGER Composer: NVARCHAR(2 Milliseconds INTEGER Bytes. INTEGER UnitPrice NUMERIC artists Artistid. INTEGER Name NVARCHAR(120)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started