SELECT   title_id, SUM(qty)
FROM     sales 
GROUP BY title_id
GO

SELECT   title_id, SUM(qty) AS "總銷售"
FROM     sales
GROUP BY title_id
GO

SELECT   type, pub_id, AVG(price) AS "Average Price"
FROM     titles
GROUP BY type, pub_id
GO

SELECT   type, pub_id,AVG(price) AS "平均價格"
FROM     titles
WHERE    royalty = 15
GROUP BY ALL type, pub_id 
GO

下面的代碼通過用HAVING來查找平均價格高于$10的書籍。
SELECT   type, pub_id, AVG(price) AS "平均價格"
FROM     titles
GROUP BY type, pub_id
HAVING   AVG(price) > 10.00
GO

用戶還可以在語句中使用邏輯操作AND。
SELECT   type, pub_id, AVG(price) AS "平均價格"
FROM     titles
GROUP BY type, pub_id
HAVING   AVG(price) >= 10.00 AND
         AVG(price) <= 30.00
GO

用戶可以使用BETWEEN子句，代替上面實例中的AND操作，代碼如下：
SELECT   type, pub_id, AVG(price) AS "平均價格"
FROM     titles
GROUP BY type, pub_id
HAVING   AVG(price) BETWEEN 10.00 AND 20.00
GO

SELECT   SUM(price)
FROM     titles
WHERE    type = 'mod_cook'
HAVING   SUM(price) > 10
GO

SELECT   au_lname, au_fname
FROM     authors
ORDER BY au_lname ASC
GO

SELECT   job_id, lname, fname
FROM     employee
ORDER BY job_id, lname, fname
GO

用戶可以在ORDER BY子句使用的同時，還可以使用GROUP BY子句：
SELECT   type, pub_id, AVG(price) AS "Average Price"
FROM     titles
GROUP BY type, pub_id
ORDER BY type
GO

用戶還可以使用自定義的詞組進行排序：
SELECT   type, pub_id, AVG(price) AS "平均價格"
FROM     titles
GROUP BY type, pub_id
ORDER BY '平均價格'
GO

SELECT   city, state
FROM     publishers
UNION    SELECT city, state
         FROM   stores
GO

用戶可以的定義列的名稱，代碼如下：
SELECT   city AS "所有城市", state AS "所有地區" 
FROM     publishers
UNION    SELECT city, state
         FROM   stores
GO

如果通過同一個表查詢，就不用再寫一次SELECT語句：
SELECT   city, country
FROM     publishers
UNION    SELECT city, state
         FROM   stores
GO

用戶還可以在查詢語句時，使用GROUP BY 或者HAVING。
SELECT   type AS "類型" , COUNT(title) AS "標題個數" 
FROM     titles
GROUP BY type
UNION    SELECT   pub_name, COUNT(titles.title)
         FROM     publishers, titles
         WHERE    publishers.pub_id = titles.pub_id
         GROUP BY pub_name
GO

COUNT可以計算查詢結果的個數：
SELECT   COUNT(*)
FROM     publishers
GO

AVG、COUNT、MAX、MIN和SUM 功能都可以使用ALL 和 DISTINCT操作。實例如下：
SELECT   MAX(price) - MIN(price) AS "價格差異"
FROM     titles
GO

在下面的實例中，SUM將計算總和：
SELECT   stores.stor_name, SUM(sales.qty) AS "全部項目排序" 
FROM     sales, stores
WHERE    sales.stor_id = stores.stor_id
GROUP BY stor_name
GO