Question: Display all columns from the Addresses table for those addresses that are located in New Jersey and have a value in the Line2 column

Display all columns from the Addresses table for those addresses that are located in New Jersey and have a 

Display all columns from the Addresses table for those addresses that are located in New Jersey and have a value in the Line2 column (hint: not a null). Order the results by ZinCode in ascending order. Problem #2: 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 # 3: 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 # of orders value is greater than one. Order the results in descending order by the # of orders. Hint: [order value = (temprice Quantity)-DiscountAmount]. Problem #4: Display the CategoryID and CategoryName columns from the Categories table that do not have any associated Products. **MUST USE A JOIN. Problem #5: Display the CategoryID and CategoryName columns from the Categories table that do not have any associated Products. **MUST USE A SUBQUERY. Problem #6: 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Problem 1 SELECT FROM Addresses WHERE State NJ AND Line2 IS NOT NULL ORDER BY ZipCode ASC Problem 2 ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!