Subject SQL

-TIA

1).Write a query to display the product name, units in stock, unit price, and the total dollar amount of the units in stock from the products table. Name the columns Product, QoH, Price, and Total respectfully.

2).Write a query to display all the orders from the orders table, using the minimum code possible.

3). Write a query to display the employees title of courtesy, first name, and last name, as a single column and name the column Title, also display the employees hire date and name that column Hired.

4). Write a query to display all the shippers from the shippers table. Name the columns ID, Name, and Phone respectfully.

5). Write a query to display the unique territory descriptions from the territories table.