Consider the following two tables: Table1: Customers customerID Fname Lname email City ZipCode 100 Salma Amri salma@gmail.com Salalah 211 101 Rami Kalabani Rami@hotmail.com Sohar 205 102 Adnan Harthi Adnan@yahoo.com Sur 201 103 Amro Alshukaili Amro@gmail.com Bahla 208 104 Maatz Rawas Maataz@gmail.com Salalah 211 Table2: Orders orderID orderDate amount customerID 1 07/04/2019 234$ 100 2 03/14/2020 78$ 103 3 05/23/2019 124$ 102 5 07/21/2018 25$ 104 6 11/27/2019 14$ 102 7 12/07/2020 55$ 106 Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it). 1. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount FROM Customers AS c INNER JOIN Orders AS o ON c. customerID = o. customerID; 2. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount FROM Customers AS c LEFT OUTER JOIN Orders AS o ON c. customerID = o. customerID; 3. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount FROM Customers AS c RIGHT OUTER JOIN Orders AS o ON c. customerID = o. customerID;
Consider the following two tables:
Table1: Customers
|
customerID |
Fname |
Lname |
|
City |
ZipCode |
|
100 |
Salma |
Amri |
salma@gmail.com |
Salalah |
211 |
|
101 |
Rami |
Kalabani |
Rami@hotmail.com |
Sohar |
205 |
|
102 |
Adnan |
Harthi |
Adnan@yahoo.com |
Sur |
201 |
|
103 |
Amro |
Alshukaili |
Amro@gmail.com |
Bahla |
208 |
|
104 |
Maatz |
Rawas |
Maataz@gmail.com |
Salalah |
211 |
Table2: Orders
|
orderID |
orderDate |
amount |
customerID |
|
1 |
07/04/2019 |
234$ |
100 |
|
2 |
03/14/2020 |
78$ |
103 |
|
3 |
05/23/2019 |
124$ |
102 |
|
5 |
07/21/2018 |
25$ |
104 |
|
6 |
11/27/2019 |
14$ |
102 |
|
7 |
12/07/2020 |
55$ |
106 |
Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it).
1. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount
FROM Customers AS c
INNER JOIN Orders AS o
ON c. customerID = o. customerID;
2. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount
FROM Customers AS c
LEFT OUTER JOIN Orders AS o
ON c. customerID = o. customerID;
3. SELECT c.Fname, c.Lname, c.email, o.orderDate, o.amount
FROM Customers AS c
RIGHT OUTER JOIN Orders AS o
ON c. customerID = o. customerID;
Step by step
Solved in 3 steps with 3 images
