Structure of the ORDERS table

-Based upon the structure of the ORDERS table,which of the following is a valid SQL statement?
A) none of the above
B) SELECT customer # FROM orders;
C) SELECT "order#","customer#" FROM orders;
D) SELECT order#,orderdate DateOrdered FROM orders;

Question

Structure of the ORDERS table
 
-Based upon the structure of the ORDERS table,which of the following is a valid SQL statement?​
A) ​none of the above 
B) ​SELECT customer # FROM orders; 
C) ​SELECT "order#","customer#" FROM orders; 
D) ​SELECT order#,orderdate DateOrdered FROM orders;

Quizplus · Accepted Answer

The valid SQL statement is selecting the order# and creating an alias for the orderdate column as DateOrdered. The # sign in the column name should be avoided as it can cause problems in SQL syntax.

Structure of the ORDERS Table