SQL ASSIGMENT

EXERCISE 49:

Select the customer name and website URL for customers that have placed orders before January 16, 2013.

EXERCISE 50:

Find the person (people) name, quantity of items ordered from people, orders and order lines.

EXERCISE 51:

Using the customers, invoices and invoice lines table, produce a report of the customer name, invoice date, quantity of items as TotalQuantity and extended price as TotalPrice for each

EXERCISE 52:

Using the query from exercise 51, produce the Top 10 TotalPrices.

EXERCISE 53:

By customer name, determine and present the number of invoices as NumberOfInvoices, the total quantity of items purchased and the total extended price.

EXERCISE 54:

Which is the best customer as defined by TotalExtendedPrice?

EXERCISE 55:

Explain what the following query does and how many rows returned.

select StockItemName, sum(Quantity)as Total

from Warehouse.StockItems SI

join Sales.OrderLines OL

on SI.StockItemID= OL.StockItemID

groupby StockItemName;

EXERCISE 56:

Explain what the following query does and how many rows returned.

select SupplierName, OrderDate

from Purchasing.Suppliers Sup

join Purchasing.PurchaseOrders PO

on SUP.SupplierID= PO.SupplierID

where OrderDate='20200415';

EXERCISE 57:

Which symbol is used to apply a wildcard in Access and which is used to apply a wildcard in SQL Server?

EXERCISE 58:

Which symbol is used to append in Access and which is used to append in SQL Server?

EXERCISE 59:

Which keyword is used to filter the results when the filter is on an aggregation?

EXERCISE 30:

In an aggregation query, what keywords are used on columns that are not being aggregated?