SQL FORM

6. Create a list of all the products (prod_id and name) if all the following are true (7 records) Supplierid = 2, 5, 16, 8, or 9 Categoryid = 1, 2, or 4 Unitprice > 15.00 */

/* 7. Create a list of all the products (prod_id and name) if all the following are true (11 records)

Supplierid = 2, 5, 16, 8, or 9 AND Categoryid = 1, 2, or 4 AND Unitprice > 15.00 OR Supplierid = 1, 4, 8 AND categoryid= 3 or 4 */

/* 8. Create a list of product names that have the second letter of the name = h (8 records) */

/* 9. Create a list of product names that have the second letter of the name = a and the last letter = e (2 records) */

/* 10. List all the customers that have one of the following fields NULL (Region or Fax). Also the title of the contact should be Owner Sort the list by contact name (14 records) */

/* 11. List each employees name (first and last in one column) and their birthdate. Sort the list by birthdate. */

/* 12. Which employees were born in 1963? */

Suppliers * SupplierID Company Name Contact Name ContactTitle Address City Region PostalCode Country Phone Fax HomePage Products ProductID ProductName SupplierID CategoryID QuantityPerUnit Unit Price UnitsInStock Units OnOrder ReorderLevel Discontinued Order Details OrderID * ProductID UnitPrice Quantity Discount Orders OrderID CustomerID EmployeeID OrderDate RequiredDate ShippedDate Ship Via Freight Ship Name ShipAddress Ship City Ship Region ShipPostalCode Ship Country Customers * CustomerID CompanyName ContactName ContactTitle Address City Region PostalCode Country Phone Fax Categories CategoryID CategoryName Description Picture Shippers * ShipperID CompanyName Phone Employees EmployeeID LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region PostalCode Country Home Phone Extension Photo Notes ReportsTo Suppliers * SupplierID Company Name Contact Name ContactTitle Address City Region PostalCode Country Phone Fax HomePage Products ProductID ProductName SupplierID CategoryID QuantityPerUnit Unit Price UnitsInStock Units OnOrder ReorderLevel Discontinued Order Details OrderID * ProductID UnitPrice Quantity Discount Orders OrderID CustomerID EmployeeID OrderDate RequiredDate ShippedDate Ship Via Freight Ship Name ShipAddress Ship City Ship Region ShipPostalCode Ship Country Customers * CustomerID CompanyName ContactName ContactTitle Address City Region PostalCode Country Phone Fax Categories CategoryID CategoryName Description Picture Shippers * ShipperID CompanyName Phone Employees EmployeeID LastName FirstName Title TitleOfCourtesy BirthDate HireDate Address City Region PostalCode Country Home Phone Extension Photo Notes ReportsTo