Consider the following two tables: Table1: Products productID productName unitPrice entryDate expiryDate P1 Dell Laptop 350 16-10-2016 30-10-2016 P2 Apple mobile 420 17-02-2018 02-03-2018 P3 Samsung Mobile 330 20-08-2020 30-08-2020 P4 HP Printer 80 21-09-2019 05-10-2019 P5 Canon Printer 150 15-05-2020 20-06-2020 Table2: Orders orderID Quantity Price productID 1 10 3300 P3 2 5 1800 P1 3 20 1600 P4 4 20 3000 P5 5 9 1100 P7 6 8 2250 P10 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 p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p INNER JOIN Orders AS o ON p. productID = o. productID; 2. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p LEFT OUTER JOIN Orders AS o ON p. productID = o. productID; 3. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p RIGHT OUTER JOIN Orders AS o ON p. productID = o. productID;
Consider the following two tables:
Table1: Products
|
productID |
productName |
unitPrice |
entryDate |
expiryDate |
|
P1 |
Dell Laptop |
350 |
16-10-2016 |
30-10-2016 |
|
P2 |
Apple mobile |
420 |
17-02-2018 |
02-03-2018 |
|
P3 |
Samsung Mobile |
330 |
20-08-2020 |
30-08-2020 |
|
P4 |
HP Printer |
80 |
21-09-2019 |
05-10-2019 |
|
P5 |
Canon Printer |
150 |
15-05-2020 |
20-06-2020 |
Table2: Orders
|
orderID |
Quantity |
Price |
productID |
|
1 |
10 |
3300 |
P3 |
|
2 |
5 |
1800 |
P1 |
|
3 |
20 |
1600 |
P4 |
|
4 |
20 |
3000 |
P5 |
|
5 |
9 |
1100 |
P7 |
|
6 |
8 |
2250 |
P10 |
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 p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price
FROM Products AS p
INNER JOIN Orders AS o
ON p. productID = o. productID;
2. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price
FROM Products AS p
LEFT OUTER JOIN Orders AS o
ON p. productID = o. productID;
3. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price
FROM Products AS p
RIGHT OUTER JOIN Orders AS o
ON p. productID = o. productID;
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
