Notes

*between is both inconclusive, useful for dates
*most common joinn is the inner join

1). selects all products with a ProductName that are not BETWEEN Carnarvon Tigers and Mozzarella di Giovanni

SELECT * FROM Products
WHERE ProductName NOT BETWEEN 'Carnarvon Tigers' AND 'Mozzarella di Giovanni'
ORDER BY ProductName;

2). Select all employees born BETWEEN'1950-01-01' AND '1968-12-31'

SELECT * FROM Employees
WHERE BirthDate BETWEEN '1950-01-01' AND '1968-12-31'
ORDER BY EmployeeID;

3). selects all products with a supplier ID BETWEEN 20 and 30. In addition; do not show products with supplier of 11,14, or 16.

SELECT * FROM Products
WHERE SupplierID BETWEEN '20' AND '30'
AND NOT SupplierID IN (11,14,16);

4). Select all the orders from the customer with CustomerID 7. Use the "Customers" and "Orders" tables, and give them the table aliases of "cust" and "Ord" respectively

SELECT Ord.OrderID, Ord.OrderDate, cust.CustomerName
FROM Customers AS cust, Orders AS Ord
WHERE cust.CustomerID=7 AND cust.CustomerID=Ord.CustomerID;

5). Write the SQL statement that creates an alias named Supplier Address that combines four columns (ContactName, Address, City, PostalCode, and Country) from Suppliers table

SELECT ContactName, Address + ', ' + City + ' ' + PostalCode + ', ' + Country AS SupplierAddress
FROM Suppliers;

6). Select all orders with customers (INNER JOIN)

SELECT Orders.OrderID, Employees.EmployeeID
FROM Orders
INNER JOIN Employees ON Orders.EmployeeID = Employees.EmployeeID;