Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Databases Object Oriented Deductive Hypermedia Technologies

Authors: Kamran Parsaye, Mark Chignell, Setrag Khoshafian, Harry Wong

1st Edition

0471503452, 978-0471503453

More Books

Students also viewed these Databases questions