part A Find the average of order quantity with item_code '200¹. part B Which item has the highest unit price? mysql> select * from order_db; | orderid | custid | itemcode | orderquantity | deliverydate 2 | 2 | 2 2 | 2 | 2 2 250 200 500 300 75 ~~~~N 2 2 B 2 5 rows in set (0.00 sec) mysql> select * from item_db; + | item_code | item_name | current_stock 10 33 | C 85 5 200 | 1 500 | 9 6 rows in set (0.00 sec) 800 600 125 200 265 100 | 300 250 | 550 | 300 | 300 2020-05-30 2021-09-21 | 2023-06-02 2020-05-29 2020-05-29 | unitprice | + 40 | 5| 150 650 15 | 100 | | | с | R | D | C | c modeofpayment | date_of_order | 2020-05-28 1998-02-15 2024-09-03 1998-02-15 1998-02-15
part A Find the average of order quantity with item_code '200¹. part B Which item has the highest unit price? mysql> select * from order_db; | orderid | custid | itemcode | orderquantity | deliverydate 2 | 2 | 2 2 | 2 | 2 2 250 200 500 300 75 ~~~~N 2 2 B 2 5 rows in set (0.00 sec) mysql> select * from item_db; + | item_code | item_name | current_stock 10 33 | C 85 5 200 | 1 500 | 9 6 rows in set (0.00 sec) 800 600 125 200 265 100 | 300 250 | 550 | 300 | 300 2020-05-30 2021-09-21 | 2023-06-02 2020-05-29 2020-05-29 | unitprice | + 40 | 5| 150 650 15 | 100 | | | с | R | D | C | c modeofpayment | date_of_order | 2020-05-28 1998-02-15 2024-09-03 1998-02-15 1998-02-15
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
100%
Transcribed Image Text:part A Find the average of order quantity with item_code '200¹.
part B Which item has the highest unit price?
Transcribed Image Text:mysql> select * from order_db;
| orderid | custid | itemcode | orderquantity | deliverydate
2 |
2 |
2
2 |
2 |
2
2
250
200
500
300
75
~~~~N
2
2 B
2
5 rows in set (0.00 sec)
mysql> select * from item_db;
+
| item_code | item_name | current_stock
10
33 | C
85
5
200 | 1
500 | 9
6 rows in set (0.00 sec)
800
600
125
200
265
100 |
300
250 |
550 |
300 |
300
2020-05-30
2021-09-21
| 2023-06-02
2020-05-29
2020-05-29
| unitprice |
+
40 |
5|
150
650
15 |
100 |
|
| с
| R
| D
| C
| c
modeofpayment | date_of_order |
2020-05-28
1998-02-15
2024-09-03
1998-02-15
1998-02-15
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 1 steps with 2 images
Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education