// display all Customers
FROM Customer
or
SELECT c FROM Customer AS c

// display Customer #2
FROM Customer c
WHERE c.customerID=2                       
or
SELECT c FROM Customer AS c
WHERE c.customerID=2          

// display all Products
FROM Product
or
SELECT p FROM Product AS p

// display Product #2
FROM Product p
WHERE p.productID=2
or
SELECT p FROM Product AS p
WHERE p.productID=2  

// display all incomplete orders
FROM Order o
WHERE o.isComplete=false
or
SELECT o FROM Order o
WHERE o.isComplete=false

// line items with quantity larger than 22
FROM LineItem li
WHERE li.quantity>22
or
SELECT li FROM LineItem li
WHERE li.quantity >= 23        

// display count of products
SELECT COUNT(p) FROM Product AS p

// display average product price
SELECT AVG(p.price) FROM Product p

// display all customers sorted
// by area code in descending order
FROM Customer c 
ORDER BY c.phone DESC
or 
SELECT c FROM Customer AS c 
ORDER BY c.phone DESC

// display all products that are
// lenses but are not filters
SELECT p FROM Product p
WHERE LOCATE('lens', p.description) <> 0 AND
LOCATE('filter', p.description) = 0

// display all products with above average prices
SELECT p FROM Product AS p 
  WHERE p.price > 
    (SELECT AVG(x.price) FROM Product AS x) 
    