Question: WRITE OUT THE OUTPUT FROM THE SQL QUERY! Tables Customers ID Name Street City Zip email 1 Emily 101 Anza St San Francisco 94118 emily@g-mail.com

WRITE OUT THE OUTPUT FROM THE SQL QUERY!

Tables

Customers

ID

Name

Street

City

Zip

email

1

Emily

101 Anza St

San Francisco

94118

emily@g-mail.com

2

Amy

1 Houston Ave

New York

12111

amy@g-mail.com

3

John

29 Sunset Blvd

Los Angeles

45643

john@yahoo.com

4

Pam

800 Market St

San Francisco

94080

pam@msn.com

5

Sue

400 Muir Ave

Redwood City

94598

sue@g-mail.com

6

Chris

987 A Ave

New York

13111

chris@aol.com

7

Todd

788 Harrison St

San Francisco

94117

todd@g-mail.com

Products

ID

Product_name

Price

Quantity

1

Metal pen

5.99

20

2

Surge protector

25.99

0

3

pencil

7.25

59

4

Replacement screen

75.25

54

5

PC monitor

200.5

6

6

Magic mouse

125.99

0

7

iphone charger

101.99

0

orders

ID

Customer_id

Products_id

Order_number

Order_date

Delivery

1

5

5

101

2017-10-01

Shipping

2

3

3

102

2017-10-02

Pickup

3

3

4

102

2017-10-02

Pickup

4

2

1

103

2017-10-04

Shipping

5

2

2

103

2017-10-04

Pickup

Given the data in the tables and the SQL query, what would the output look like?

WRITE OUT THE OUTPUT FROM THE SQL QUERY! Tables

WRITE OUT THE OUTPUT FROM THE SQL QUERY! Tables

1. SELECT Name FROM customers WHERE City = 'San Francisco 2. Select C.ID, C.name, O.Delivery From Customers C Join Orders 0 ON C.ID = 0.Customer_ID Where O.Delivery = 'Shipping' Group by C.ID, C.name 3. SELECT Product_name, Count(*) as count_of_products FROM products WHERE Price BETWEEN 2 and 100 GROUP BY Product_name 4. SELECT Product_name, Price, Count(*) as count_of_products FROM products WHERE Quantity > 5 GROUP BY Product_name, price ORDER BY Price ASC 5. SELECT Orders.ID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerlD = Customers.CustomerlD

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!