Data analysis project This project is comprised of four separate parts. The first three parts will analyze aggregated data obtained from...

I don't know how to translate questions into SQL Code. Please help me with questions 1-5.

Download and open Part_B_National_Summary.accB in Microsoft Access 2010. This is a database generated from spreadsheets for 2009 and 2010 downloaded from http://www.healthdata.gov. The Medicare Part B national datasets are summarized by meaningful Healthcare Common Procedure Coding/Current Procedural Terminology (HCPC/CPT) code ranges. Each data set displays the allowed services, allowed charges, and payment amounts by HCPCS/CPT codes and prominent modifiers. In addition, there is a README file (PartBNationalSummaryReadmeFile2010.pdf) available in this unit that provides additional information about the datasets. Using SQL statements, answer the following questions:

1. Which Description has the most HCPCS codes?

2. What was the difference between Payment and Allowed Charges for HCPCS codes associated with ‘INTEGUMENTARY’ in 2009?

3. Name the HCPCS codes with the five (5) highest number of allowable services in 2009.

4. Determine and report total payments associated ‘cardiovascular’ procedures in 2010.

5. What are the top five (5) HCPCS as determined by Total Payment in 2010? Report the procedure corresponding to each HCPCS code to a level greater than available in the database. That is, look up the HCPCS codes to reveal precisely what they are coding for.

Taken from the CMS site: "Each year, in the United States, health care insurers process over 5 billion claims for payment. For Medicare and other health insurance programs to ensure that these claims are processed in an orderly and consistent manner, standardized coding systems are essential. The HCPCS Level II Code Set is one of the standard code sets used for this purpose. The HCPCS is divided into two principal subsystems, referred to as level I and level II of the HCPCS. Level I of the HCPCS is comprised of CPT (Current Procedural Terminology), a numeric coding system maintained by the American Medical Association (AMA). The CPT is a uniform coding system consisting of descriptive terms and identifying codes that are used primarily to identify medical services and procedures furnished by physicians and other health care professionals."

So...the idea is for you to find out that CPT code 66984 is for cataract surgery....the HCPCS codes in this database are Level 1, CPT codes.

There are various resources available on the web, such as (but not limited to) http://www.cms.gov/apps/physician-fee-schedule/search/search-criteria.aspx OR just Google CPT or HCPCS + your five digit code and you will get the information. DO NOT pay anything for this information.

Attachment 1
Attachment 2