Structure of the ORDERS Table

Structure of the ORDERS table

-Which of the following is a valid SELECT statement?​

A) ​SELECT order# || ' was shipped on ' || shipdate;
B) ​SELECT order# || " was shipped on " || shipdate;
C) ​none of the above
D) ​SELECT order#,|| ' was shipped on ' || shipdate;