Having 與 AS

• Having 配合group by 限定查出來的資料
• select cid,sum(num) from sale group by cid having sum(num) > 3
• AS 用來設定欄位標題
• Select name as 姓名, address as 住址 from main;