orders orderid · customer 1 adam 22 john 3 paul 13 john 18 paul - item unitprice - quantity • apples apples bananas $55.00 29 30 29 $40.00 $29.99 bananas $29.99 bananas $40.00 20 paul bananas $40.00 5 heather 6 paul 4 heather $12.00 10 22 grapes grapes $12.00 oranges $34.50 18

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

please do this

As
Write SQL queries for the following requirements
ld or create
曲 orders
k as Done
orderid · customer - item • unitprice - quantity -
apples
apples
adam
$55.00
29
22 john
3 рaul
13 john
18 paul
20 paul
5 heather
6 paul
$40.00
30
$29.99
$29.99
bananas
29
bananas
4
nts
bananas
$40.00
bananas
$40.00
4.
comment
grapes
$12.00
10
22
18
grapes
$12.00
4 heather
oranges
$34.50
1. Display all data from the orders table.
2. Display all data of the table orders which have unit price more than $30.00
3. Display customers who purchased apples.
4. Display items which are purchased without repeating items
5. Display information of order number 13.
Page 1 I 1
Q +
Transcribed Image Text:As Write SQL queries for the following requirements ld or create 曲 orders k as Done orderid · customer - item • unitprice - quantity - apples apples adam $55.00 29 22 john 3 рaul 13 john 18 paul 20 paul 5 heather 6 paul $40.00 30 $29.99 $29.99 bananas 29 bananas 4 nts bananas $40.00 bananas $40.00 4. comment grapes $12.00 10 22 18 grapes $12.00 4 heather oranges $34.50 1. Display all data from the orders table. 2. Display all data of the table orders which have unit price more than $30.00 3. Display customers who purchased apples. 4. Display items which are purchased without repeating items 5. Display information of order number 13. Page 1 I 1 Q +
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY