Questions from Database Management

Q: Display the product ID and the number of orders placed for each

Display the product ID and the number of orders placed for each product. Show the results in decreasing order by the number of times the product has been ordered and label this result column NumOrders...

Q: For each payment made on or after March 10, 2018,

For each payment made on or after March 10, 2018, list PaymentID, OrderID, PaymentAmount, and the first 10 characters of PaymentComment.

Q: For each customer, list the customer ID and the total number

For each customer, list the customer ID and the total number of orders placed in 2018.

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

For each salesperson, list the total number of orders.

Q: For each customer who had more than two orders, list the

For each customer who had more than two orders, list the CustomerID and the total number of orders placed.

Q: Assume that for those materials the ID of which starts with a

Assume that for those materials the ID of which starts with a numeric character, the last three letters of the ID represent a wood type. Further, assume that the numeric part of MaterialID (everything...

Q: List all sales territories (TerritoryID) that have more than one

List all sales territories (TerritoryID) that have more than one salesperson.

Q: Which product is ordered most frequently?

Which product is ordered most frequently?

Q: Select a suitable programming language and outline how a transaction rollback can

Select a suitable programming language and outline how a transaction rollback can be coded. Annotate your code to provide clear instructions of what is happening.

Q: For employees who live in TN or FL, list the age

For employees who live in TN or FL, list the age at which they were hired.