// 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) 

    