Answer:
a. SELECT order_id, order_date, order_source_id, source_description, first_name || last_name AS customer_name
FROM customer_order;
b. SELECT order_id, order_date, meth_pmt, first_name || last name AS customer_name
FROM customer_order;
c. SELECT shipment_id, inv_id, ship_quantity, date_expected, date_received
FROM shipment_line;
Explanation:
When using SQL statements to display a certain amount of information, the SELECT syntax is used. It is written as;
SELECT X, Y, Z
FROM alphabets;
The SELECT statement is used to list the variables to be displayed which are usually separated by a coma.
The FROM indicates the table from which the variables should be extracted from.
The ; sign signifies the end of an SQL statement and that you want your query to be run
This "first_name || last_name AS customer_name" tells SQL to combine the first and last name of customers and display them as customer_name.
