Questions from Database Management

Q: Measured by average standard price, what is the least expensive product

Measured by average standard price, what is the least expensive product finish?

Q: Display the territory ID and the number of salespersons in the territory

Display the territory ID and the number of salespersons in the territory for all territories that have more than one salesperson. Label the number of salespersons NumSalesPersons.

Q: Display the SalesPersonID and a count of the number of orders for

Display the SalesPersonID and a count of the number of orders for that salesperson for all salespersons except salespersons 3, 5, and 9. Write this query with as few clauses or components as possible,...

Q: For each salesperson, list the total number of orders by month

For each salesperson, list the total number of orders by month for the year 2018. (Hint: If you are using Access, use the Month function. If you are using Oracle, convert the date to a string, using t...

Q: List MaterialName, Material, and Width for raw materials that are

List MaterialName, Material, and Width for raw materials that are not cherry or oak and whose width is greater than 10 inches. Show how you constructed this query using a Venn diagram.

Q: List ProductID, ProductDescription, ProductFinish, and ProductStandardPrice for oak products

List ProductID, ProductDescription, ProductFinish, and ProductStandardPrice for oak products with a ProductStandardPrice greater than $400 or cherry products with a StandardPrice less than $300. Show...

Q: For each order, list the order ID, customer ID,

For each order, list the order ID, customer ID, order date, and most recent date among all orders. Show how you constructed this query using a Venn diagram.

Q: For each customer, list the customer ID, the number of

For each customer, list the customer ID, the number of orders from that customer, and the ratio of the number of orders from that customer to the total number of orders from all customers combined. (T...

Q: For products 1, 2, and 7, list in one

For products 1, 2, and 7, list in one row and three respective columns that product’s total unit sales; label the three columns Prod1, Prod2, and Prod7.

Q: Examine the hierarchy for the university EER diagram. As a student

Examine the hierarchy for the university EER diagram. As a student, you are an instance of one of the subtypes: either UNDERGRAD STUDENT or GRADUATE STUDENT. List the names of all the attributes that...