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

Question

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

Quizplus · Accepted Answer

The Answer of  
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

Structure of the ORDERS Table