Homework

• Return a list of all the produce names.

  SELECT ProductName
  FROM Products;
  	  

• Return the company names of all the customers in Paris, France.

  SELECT CompanyName, City
  FROM Customers
  WHERE City = "Paris" AND Country = "France";
  	    

• 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 supplier.

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

Personal Database Project

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