Instructions

Problems

Please write queries based on the following requirements using WideWorldImporters Database. For each question, you are required to submit 1) SQL query code; 2) a screen shot of your query result (if the result has more than 15 records, you only need to take a screen shot of the top 15 records).

List all the customer name and the delivery postal code of customers, arrange the results in ascending order on customer name. (Use [Sales].[Customers] Table)

List all the customer name and the delivery postal code of customers, where the delivery address line 1 starts with the word Shop arrange the results in ascending order on customer name. (Use [Sales].[Customers] Table)

How many customers have a delivery postal code different than the postal postal code. (Use [Sales].[Customers] Table)

How many invoices were created on January of 2013. (Use [Sales].[Invoices] Table)

List the count of invoices grouped by the number of total dry items. List only the top 2 largest counts. (Use [Sales].[Invoices] Table)

List the total dry items quantity for all invoices. (Use [Sales].[Invoices] Table)

List earliest invoice date for each delivery method ID. (Use [Sales].[Invoices] Table)

List the top 3 most recent transactions for customer id different than 1 and an amount excluding tax greater than 300. (Use [Sales].[CustomerTransactions] Table)

List the top 10 customer IDs based on their transaction amount. For this report, make sure to exclude all transactions that occurred on the first 10 days of the month (Use [Sales].[CustomerTransactions] Table).

Show the highest, lowest, and average transaction amount for transactions that happen on a Monday or including only customers with an even customer ID. (Use [Sales].[CustomerTransactions] Table)