SQL programming: calculate the average cost of each diagnosis sorted from most expensive to least expensive.

SQL programming

  • Import data from the following files into four tables. ptid.xls► claims.xls► icd.xls► cpt.xls►
  • Identify patients that have diabetes in the above database.
  • Calculate the average cost of each diagnosis sorted from most expensive to least expensive. Exclude all bills with negative or 0 values.
  • Show if men are more likely to have diabetes than women. s. Calculate which month is most likely to have a diagnosis reported.