Question

List the order number and order date for each order placed by the customer named johnson s department store. (hint: to enter an apostrophe (single quotation mark) within a string of characters, type two single quotation marks.)

Answer 1

Answer:

Explanation:

To obtain the needed detail of order table and order date for each order place by customer, has to be filtered with "John's Department Store"

select ORDER_NUM, ORDER_DATE frome orders as o

inner join customer as c on c.CUSTOMER_NUM=o.CUSTOMER_NUM

where c.CUSTOMER_NAME = "Johnson's Department Store"