Using Teradata

ViewPoint Database: db_pvfc11_big

1. List the names the number of products, and the average product price of each product line whose average price is greater than $200.

2. List the name of each employee, his or her birth date, the name of his or her manager, and the managers birth date for those employees who were born before their manager was born; label the managers data Manager and ManagerBirth.

3. List each item ordered for order number 1, its standard price, and the total price for each item ordered.

4. Display the names of the states in which customers reside but for which there is no salesperson residing in the state. Use the set command UNION, INTERSET, or MINUS in your query.

5. Show the customer ID and name for all the customers who have ordered both products with IDs 3 and 4.