Please use Teradata SQL Assistant or MS-Access to retrieve data tables based on the following data retrieval requirements (one data table per requirement).

Requirement 4:

Display Product_ID, Product Description, Product_Finish and Standard_Price in the table Product_T;

Select all the products that are priced above $180 (hint: WHERE Standard_Price > 180)

Sort the result set by Product_ID in ascending order.

Requirement 5:

Select all the products of which the product finishes are Cherry, Walnut or Natural Ash in the table Product_T;

Calculate and display the number of products as well as the average product prices. (hint: SELECT COUNT (*), AVG(Standard_Price) FROM WHERE ).

Requirement 6:

SELECT all the desk products in the table Product_T (hint: use the WHERE clause in Requirement 3);

Calculate and display the number of products, the average, the lowest and highest product prices. (hint: SELECT COUNT (*), AVG(Standard_Price) FROM WHERE ).