Question: MYSQL database : 1) Table OrderItems contains the items within each order. Write a SQL statement that return a list of order numbers (order_num) and

MYSQL database :

1) Table OrderItems contains the items within each order. Write a SQL statement that return a list of order numbers (order_num) and the total quantity of items for each order.

2) Modify number 1 but it only returns orders of at least 100 items, and sort the results from largest order to smallest.

table orderitems:

column are :

order_num, order_item, prod_id, quantity, item_price

'20005', '1', 'BR01', '100', '5.49' '20005', '2', 'BR03', '100', '10.99' '20006', '1', 'BR01', '20', '5.99' '20006', '2', 'BR02', '10', '8.99' '20006', '3', 'BR03', '10', '11.99' '20007', '1', 'BR03', '50', '11.49' '20007', '2', 'BNBG01', '100', '2.99' '20007', '3', 'BNBG02', '100', '2.99' '20007', '4', 'BNBG03', '100', '2.99' '20007', '5', 'RGAN01', '50', '4.49' '20008', '1', 'RGAN01', '5', '4.99' '20008', '2', 'BR03', '5', '11.99' '20008', '3', 'BNBG01', '10', '3.49' '20008', '4', 'BNBG02', '10', '3.49' '20008', '5', 'BNBG03', '10', '3.49' '20009', '1', 'BNBG01', '250', '2.49' '20009', '2', 'BNBG02', '250', '2.49' '20009', '3', 'BNBG03', '250', '2.49'

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 Databases Questions!

1. Write n SQL statement to list all cities and states of vendor addresses. Make sure the result does not include duplicates. 2. Write n SQL statement to list the item ID, item description and item...

MYSQL DATABASE: 1) Using a simple equijoin (joined using the WHERE clause) or INNER JOIN syntax, write a SQL statement to return customer name (cust_name) from the Customers table and related order...

MYSQL DATABASE: 1) Using a subquery, return a list of customers who bought items priced 10 or more. Youll want to use the OrderItems table to find the matching order numbers (order_num), and then the...

Using SQL Server to create the queries below: You should copy/paste the SQL code, followed by the data/results onto this Word Document. NOTE : It is easier if you use a clipping tool for the data set...

MySQL : Retrieve order Database UNSOLVED Environment Specifications & Instructions Type of Database MySQL Database Name to be used OrderDb Problem Statement Write a MySQL query to retrieve a list of...

1. Write a SQL statement that selects these columns: The count of the number of products in the Products table The average of the list_price columns in the Products table (4 points) 2. Write a SQL...

MYSQL DATABASE: 1) Use an OUTER JOIN to join the Products and OrderItems tables, returning a sorted list of product names (prod_name) and the order numbers (order_num) associated with each. 2) Modify...

1) Create a SQL statement to list all products from order_detail table (also called order line items table, same hereafter). But don't list any product more than once in the report. 2) Your...

Using a library database as an example, you will demonstrate how to retrieve data, insert data, and join tables using SQL. Assignment Instructions Assignment 2 contains 5 sections. You are required...

Assignment setup: # if you're installing this on your own computer, un-comment and run the following lines, so that you place the tables into their own schema drop schema if exists Assignment2;...

The load shown in Figure 7 consists of a resistance R in parallel with a capac- itor of reactance X. The load is fed from a single-phase supply through a line of impedance 8.4+j11.2 . The rms voltage...

Following are some of the countys governmental funds. The county has asked you to determine is any of the funds listed should be classified as major funds based on the GASB size criteria. Clearly...

For money that is not currently being used but the person would like to keep liquid for purposes of emergencies or opportunities, what would be an appropriate cash account to store those dollars?...

Laura transfers $522,500 into trust with the income to be paid annually to her spouse, William, for life (a life estate) and the remainder to Jenny. Calculate the amount of the taxable gifts from the...

Meeting schedules, work assignments, and vacation schedules need to be carefully coordinated. Job sharers should plan overlap times during which to meet and communicate.

Performance evaluations of job sharers need to include both an individual and a team appraisal.

6. Complete the self-assessment exercise in Table 11.4. What changes would you make in the exercise to improve it?