Problem #1: Display all columns from the Products table for those products where the ProductName column includes the keyword “drum” and does not include the keyword “ludwig”. Order the results by ProductID in ascending order.
Problem #2: Display the EMailAddress column from the Customers table along with the # of orders associated with the customer (use an alias of ‘# of orders’) and the total orders value (use an alias of ‘Total Orders Value’) for the customer. Only show those customers where the total orders value is greater than one. Order the results in descending order by the # of orders.
Hint: [order value = (Itemprice*Quantity)-DiscountAmount].
Problem #3: Display the EMailAddress column from the Customers table and all associated CategoryName’s from the Category table. Order the results in ascending order by EMailAddress and CategoryName.
Hint: You will be joining 5 tables
Problem #4: Display OrderID’s from the Orders table and the orders values of the associated OrderItems’s from the OrderItems table. Only show those orders where the order value is more than $300. Order the results in descending order by the sum of the order values.
Hint: [order value = (Itemprice*Quantity)-DiscountAmount].
Welcome to one of the bestassignmenthelpcompanies online .
· Do you want to order for a customized assignment help task?
· Click on the order now button
· Set up your topic, Fix the number of pages, Fix your Order instructions
· Set up your deadline, upload the necessary files required to complete the task, Complete the payment.
We delivery high quality and non plagiarized tasks within the stipulated time given
SL
