Lab 4 Part 2
Lab 4 Part 1
SELECT S. CompanyName, Count (P. ProductID) as "No. of Products"
FROM Suppliers S INNER JOIN Products P
ON S. SupplierID = P. SupplierID
GROUP BY S. CompanyName;
SELECT O. OrderID, Convert (varchar, O.
Lab 6 Part 1
What is Expr1 and the other verbage after Name? What woud the alias be?
Part 2 Yearly Sales by Category Report
The year 2003 showed significant improvement all around. Using this information, the company
can use the sa
Part 1 Products by Category Report
Part 2 Sales by Territory Report
What is the area for Southwest?
It seems that more product is being sold in this area and the company needs to find the
reason for the sales. The company can then use these