IS 341: Project 5 Solution
20 HW points, 10 PDP points

Homework

• Return a list of all the category names.

SELECT CategoryName
FROM Categories;

• Return the company names of all the customers from London, UK.

SELECT CompanyName, City
FROM Customers
WHERE City = "London" AND Country = "UK";

• Return the fullnames of the employees, alphabetized by last, then first name.

SELECT Firstname + ' ' + LastName
FROM Employees
ORDER BY LastName, FirstName;

• Return the order ID, customer name, and the names of the products for each customer order

SELECT Orders.OrderID, ContactName, ProductName
FROM Products, [Order Details], Orders, Customers
WHERE Products.ProductID = [Order Details].ProductID 
  AND [Order Details].OrderID  = Orders.OrderID
  AND Orders.CustomerID = Customers.CustomerID;

• Return the number of products from each category.

SELECT CategoryID, COUNT(CategoryID)
FROM Products
GROUP BY CategoryID;

Personal Database Project

As usual, I accepted just about everything here, so long as you built something that made sense and did it properly.