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.