Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it).
QUESTION 16
-
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;
Step by step
Solved in 3 steps
