Consider the following two relations in a database:
CUSTOMERS:
customer_id | first_name | last_name | email | address | city | state | zipcode
1 | George | Washington | gwashington@usa.gov | 3200 Mt Vernon Hwy | Mount Vernon | VA | 22121
2 | John | Adams | jadams@usa.gov | 1250 Hancock St | Quincy | MA | 02169
3 | Thomas | Jefferson | tjefferson@usa.gov | 931 Thomas Jefferson Pkwy | Charlottesville | VA | 22902
4 | James | Madison | jmadison@usa.gov | 11350 Constitution Hwy | Orange | VA | 22960
5 | James | Monroe | jmonroe@usa.gov | 2050 James Monroe Parkway | Charlottesville | VA | 22902
ORDERS:
order_id | order_date | amount | customer_id
1 | 07/04/1776 | $234.56 | 1
2 | 03/14/1760 | $78.50 | 3
3 | 05/23/1784 | $124.00 | 2
4 | 09/03/1790 | $65.50 | 3
What are the data output for the following SQL retrieval commands? (10 points)
(a) SELECT first_name, last_name, zipcode, order_date, order_amount FROM Customers C INNER JOIN Orders O ON C.customer_id = O.customer_id;
(b) SELECT first_name, last_name, zipcode, order_date, order_amount FROM Customers C LEFT OUTER JOIN Orders O ON C.customer_id = O.customer_id;
(c) SELECT first_name, last_name, zipcode, order_date, order_amount FROM Customers C FULL OUTER JOIN Orders O ON C.customer_id = O.customer_id;
