Select* from customer;
select customer_num, fname,company,state from customer order by state
desc;
select customer_num, fname,company,state from customer order by state
asc;
select customer_num, fname,company,state from customer order by state
asc, fname desc;
select stock_num,description,unit_price,unit_price*1.1 from stock;
select stock_num,description,unit_price as OldPrice,unit_price*1.1
NewPrice from stock;
select COUNT(distinct state)as NumberStates from customer;
Select fname,lname,address1,address2,city from customer;
select* from customer where state='CA';
select distinct city from customer where state='CA';
select distinct city from customer where state='CA'order by city desc;
Select fname,lname,address1,address2 from customer where customer_num=3;
select stock_num from stock group by stock_num;
select state,COUNT(customer_num) from customer group by state;
select city,COUNT(customer_num) from customer group by city;
select description,Avg(unit_price) from stock group by description;
select* from items;