Answers to Practice Problems in
proc sql document:
Solutions using proc sql.

1. alter drugstore1 sql.pop drop store_id;

2. alter table orig add storeid num;
   update orig set storeid = store_id;
   alter table orig drop store_id;

3. insert into drugstore1 
      set product='cough medicine', 
          chain='CVS', 
          store_id=105, 
          price=6.11;

4. select price from drugstore1
      where product='cough medicine'
         and store_id=305;

5. select store_id from drugstore1
      where product='aspirin';

6. select distinct store_number from drugstore1
      where chain='CVS';

7. select * from drugstore1
      order by price descending;

8. select * from drugstore1
      order by brand, product;

9. select min(price) as MinPrice, max(price) as MaxPrice,
      mean(price) as AvgPrice from drugstore;

10. select min(price) as MinPrice, max(price) as MaxPrice,
       mean(price) as AvgPrice from drugstore
       group by brand, product;

11. select min(price) as MinPrice, max(price) as MaxPrice,
       mean(price) as AvgPrice from drugstore
       where product='aspirin'
       group by chain;

12. select store_id, phone 
       from drugstore_info
       where city='Chicago';

13. select drugstore_info.store_id, phone 
       from drugstore2, drugstore_info
       where drugstore_id.store_id = drugstore_info.store_id and
          and city='Chicago' and chain='Walgreens';

14. select mean(price) as AvgPrice 
       from drugstore2, drugstore_info
       where drugstore_id.store_id = drugstore_info.store_id
          and product='CVS';

15. select n(price) as NumberOfStores
       from drugstore2
       group by product;