QUESTION 5 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;
QUESTION 5
-
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 2 steps
