Question: E5.1 Write the SQL queries that accomplish the following tasks in the ZAGI Retail Company Sales Department Database: E5.1.18 Display the TID and the total

E5.1 Write the SQL queries that accomplish the following tasks in the ZAGI Retail Company Sales Department Database:

E5.1.18 Display the TID and the total number of items (of all products) sold within the transaction for all sales transactions whose total number of items (of all products) sold within the transaction is greater than five.

E5.1.19 For each vendor whose product sales exceed $700, display the VendorID, VendorName, and total amount of sales in dollars. Display the total amount of sales as TotalSales.

E5.1.20 Display the ProductID, ProductName, and ProductPrice of the cheapest product.

E5.1.21 Display the ProductID, ProductName, and VendorName for products whose price is below the average price of all products.

E5.1.22 Display the ProductID and ProductName of the product for the products whose total quantity sold in all transactions is greater than 2. Sort the results by ProductID.

E5.1.23 Display the ProductID for the product that has been sold the most within all transactions (i.e., that has been sold in the highest total quantity across all transactions)."

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Use MySQL Workbench to login to MySQL Server using the connection you used to do the previous lab. Write the SQL queries that accomplish the following tasks in the ZAGI Retail Company Sales...

E5.1 Write the SQL queries that accomplish the following tasks in the ZAGI Retail Company Sales Department Database: E.5.1.12 Display the ProductID, ProductName, and ProductPrice for Products whose...

E5.1 Write the SQL queries that accomplish the following tasks in the ZAGI Retail Company Sales Department Database: E5.1.1 Display all the records in the table REGION E5.1.2 Display the StoreID and...

HELP IN RELATIONAL DATABASE SYSTEMS Chapter 5 HW 321 1: What is the purpose of DDL SQL statements? 6: What is the purpose of the SELECT command? 7: What is the purpose of the WHERE condition? 13:...

Use MySQL Workbench to login to MySQL Server using the connection you used to do the previous lab. Write the SQL queries that accomplish the following tasks in the ZAGI Retail Company Sales...

Please help with E 5 . 1 . 1 - 5 . 1 . 7 . Use MySQL Workbench. - Write the SQL queries that accomplish the following tasks in the ZAGI Retail Company Sales Department Database: E 5 . 1 . 1 Display...

Home Tools Assignment 5 (Par... X Sign In d Share Q3. [Points 40] (Reference: Textbook Exercise Question E5.1a through E5.1m) Export PDF Write the SQL queries that accomplish the following tasks in...

The SQL. file is given and write and test your queries in MySOL 3. Given ER-diagram and relational schema of ZAGI a. (5 points)Write SQL statement to create database ZAGI b. (5 points)Write SQL...

Write the SQL queries that accomplish the following tasks in the ZAGI Retail Company Sales Department Database. Use the database db _ jukiced 2 _ zagi for these queries Display the ProductID and...

Leach Inc. experienced the following events for the first two years of its operations: Year 1: 1. Issued $10,000 of common stock for cash. 2. Provided $60,000 of services on account. 3. Provided...

Assume an investee has the following financial statement information for the three years ending December 31, 2022: Assume that on January 1, 2020, an investor company purchased 100% of the...

Dec. 15 The board of directors declared a dividend of $0.24 per share; capital stock issued is 120,000 shares. M260

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...