Data from one or more tables- use zag
-- Marketing needs a list of customers and what product they have purchased
-- which also shows category name and vendor name for that product.  
-- Generate query that returns customername, productname, categoryname, vendorname
-- order the list by customer name
-- Your list should contain 9 items

 

Transcribed Image Text:

category categoryid CHAR(2) categoryname VARCHAR(25) Indexes product productid CHAR(3) ◆productname VARCHAR(25) productprice DECIMAL (7,2) ++ vendorid CHAR(2) categoryid CHAR(2) Indexes ¥ 1 T 1 ▶ vendor vendorid CHAR(2) vendorname VARCHAR (25) Indexes includes productid CHAR(3) ?tid VARCHAR(8) quantity INT Indexes HH salestransaction ▾ tid VARCHAR(8) customerid CHAR (7) ◆storeid VARCHAR(3) ◆tdate DATE Indexes store storeid VARCHAR(3) storezip CHAR(5) regionid CHAR(1) Indexes ▸ H V region regionid CHAR(1) regionnam e VARCHAR(25) Indexes K >+ -H customer customerid CHAR (7) customername VARCHAR(15) customerzip CHAR (5) Indexes + saletransaction ?tid VARCHAR (8) customerid CHAR(7) ◆stored VARCHAR (3) tdate DATE Indexes 0 0 ▶ Q 0 category categoryid CHAR(2) categoryname VARCHAR(25) Indexes product productid CHAR(3) ◆productname VARCHAR(25) productprice DECIMAL (7,2) ++ vendorid CHAR(2) categoryid CHAR(2) Indexes ¥ 1 T 1 ▶ vendor vendorid CHAR(2) vendorname VARCHAR (25) Indexes includes productid CHAR(3) ?tid VARCHAR(8) quantity INT Indexes HH salestransaction ▾ tid VARCHAR(8) customerid CHAR (7) ◆storeid VARCHAR(3) ◆tdate DATE Indexes store storeid VARCHAR(3) storezip CHAR(5) regionid CHAR(1) Indexes ▸ H V region regionid CHAR(1) regionnam e VARCHAR(25) Indexes K >+ -H customer customerid CHAR (7) customername VARCHAR(15) customerzip CHAR (5) Indexes + saletransaction ?tid VARCHAR (8) customerid CHAR(7) ◆stored VARCHAR (3) tdate DATE Indexes 0 0 ▶ Q 0

Answer rating: 100% (QA)

To generate a query that meets the specified requirements we can use the SQL SELECT statement along ... View the full answer