Sql Server

--函数
select vend_name,UPPER(vend_name) as vend_name_upcase from Vendors order by vend_name;
select order_num from Orders where DATEPART(yy,order_date)=2012;
--聚集函数
--求平均
select AVG(prod_price)as avg_price from Products
--总共有多少行
select COUNT(*) as num_cust from Customers;
--求最大值
select MAX(prod_price) as max_price from Products;
--求最小值
select MIN(prod_price) as max_price from Products;
--求和
select sum(quantity)as items_ordered from OrderItems where order_num=20005;


select COUNT(*) as num_items,
       MIN(prod_price) as price_min,
   MAX(prod_price)as price_max,
   AVG(prod_price) as price_avg
   from Products;