SELECT <column list>
FROM <table names>
[WHERE <condition>]
[GROUP BY <column list>]
[HAVING <condition>]
[ORDER BY <column list>]

SELECT unitprice
FROM products
GROUP BY unitprice
ORDER BY unitprice Asc;                 

SELECT unitprice, count(*)
FROM products
WHERE unitprice <> NULL
GROUP BY unitprice
ORDER BY unitprice Desc;   

SELECT city
FROM employees
GROUP BY city
HAVING count (employeeid) >1;

SELECT customerid , count (*) [as Orders]
FROM orders
GROUP BY customerid
HAVING count (*) >1;

Select Customers.companyName as Name, count(Orders.Customerid) as Orders
From Orders , Customers
where Orders.Customerid = Customers.Customerid
group by (Customers.companyName);

SELECT  Products.ProductName,Suppliers.ContactName,Products.UnitPrice
FROM Products, Suppliers
WHERE Products.SupplierID = Suppliers.SupplierID

SELECT Categories.CategoryName, Suppliers.CompanyName
FROM Categories,Products, Suppliers
WHERE  Suppliers.SupplierID = Products.SupplierID 
        AND Products.CategoryID = Categories.CategoryID;