Question

19:31 P B . Ch. 6 HW Assignment 4 - Saved SG 59% Make db_pvfc11_big as your default database when you log into SQL Assistant: Username userid Password: Default Database: db pufc11_big Database Descriptions Provide proof of ownership by using Current_User attribute in all SELECT statements. Use the PVFC database to answer the following questions: 1. For each customer, list the CustomerID and the total number of orders placed in 2009 a. Hint: Use function EXTRACT(YEAR FROM (date)) to retrieve year from date. 2. For each salesperson, list the total number of orders. 3. For each customer who had more than two orders, list the CustomerID and the total number of orders placed. 4. Display the territory ID and the

I can provide my log in to my teradata database if necessary.
Thanks

Answer 1

Answer :

I am not having the table structure here however the below queries will give idea on how they can be formed. I have assumed some tables fom my side shouls be in the database as orders, sales,customers, etc.

1. select customer_ID, count(order_ID) from Customer where EXTRACT(YEAR FROM (date)) = 2009 group by customer_ID;

2. select salesman_ID, count(order_ID) from Sales group by salesman_ID ;

3. select customer_ID, count(order_ID) from Order where count(order_ID) > 2 group by customer_ID;

4. select territory_ID, count(salesman_ID) as NumSalesPersons from Sales where NumSalesPersons > 1 group by territory_ID;

5. SELECT * FROM Order group by ProductID order by count(ProductID) desc;