Consider the following two tables:
Table1: Products
product
ID
|
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
|
product
ID
|
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
FROMProducts AS p
INNER JOINOrders AS o
ON p. productID = o. productID;
2. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price
FROMProducts AS p
LEFT OUTER JOINOrders AS o
ON p. productID = o. productID;
3. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price
FROMProducts AS p
RIGHT OUTER JOINOrders AS o
ON p. productID = o. productID;