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

WRITE OUT THE OUTPUT FROM THE SQL QUERY Tables

WRITE OUT THE OUTPUT FROM THE SQL QUERY Tables

2. Select C.ID, C.name, 0.Delivery From Customers C Join Orders 0 ON C.ID = 0.Customer_ID Where O.Delivery = 'Shipping' Group by C.ID, C.name 5. SELECT Orders.ID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerID = 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!

Q:

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...

Q:

Tables Customers ID Name 1 Emily 2 Amy 3 John 4 Pam 5 Sue 6 Chris 7 Todd Street City 101 Anza St San Francisco 1 Houston Ave New York 29 Sunset Blvd Los Angeles 800 Market St San Francisco 400 Muir...

Q:

You are given a specification of database tables for a bookstore. Here are your tasks: PROBLEM: You are given a specification of database tables for a bookstore. Here are your tasks: 1. Copy into...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

DB Browser for SQLite - C:\Users\ACER\Downloads\Company SOLite(2).db File Edit View Tools Help New Database Open Database Write Changes Revert Changes Open Project Save Project Altach Database X...

Q:

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Q:

Background on SQL Server: Microsoft SQL Server is a popular enterprise-class DBMS that has been around for many years. SQL Server really handles SQL well, better than simpler tools such as Microsoft...

Q:

This is the bookstore.sql: DROP TABLE CUSTOMERS CASCADE CONSTRAINTS; DROP TABLE ORDERS CASCADE CONSTRAINTS; DROP TABLE PUBLISHER CASCADE CONSTRAINTS; DROP TABLE AUTHOR CASCADE CONSTRAINTS; DROP TABLE...

Q:

***Pleace reach out to me at 859-398-9677 for SQL Script. Thanks*** Chapter 7 Homework To create MSU Human Resources database, use MSU_HR_MySQL script provided. Before answering the questions, be...

Q:

Chapter 7 Homework To create MSU Human Resources database, use MSU_HR_MySQL script provided. Before answering the questions, be familiar with the database structure by referring to the database...

Q:

How to record to GENERAL JOURNAL? Borrowed $25,000 from Ace Bank, on a one year, 12% note, with interest to be paid at maturity.

Q:

What species is being oxidized and what species is being reduced in a silver oxide button battery?

Q:

How does the declaration and diatrbution of a 1 5 % stock dividend affect stochelders' equity? A . The total amount of stockholders' equity will increase. n . The balanoes of dfferent accounts in...

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...