Structure of the ORDERS Table

Multiple Choice

Structure of the ORDERS table

Structure of the CUSTOMERS table
-Which of the following is a valid SQL statement?

A) SELECT
B) SELECT * FROM customers JOIN orders ON (customer#) ;
C) SELECT c.customer#, order#, orderdate, shipdate FROM customers c, orders c
WHERE c.customer# = o.customer#;
D) both b and c