1. (5 points) make a row in the A322_990_compODH table, using your actual name (or names for a group) for name, your title = CEO, you compensation from the organization = 5 million, and the object id = "201801319349302720_public.xml". Complete other fields with values that are realistic.(schema tables: columns: Name Title HoursperWeek Income_From_Org Income_from_related_org Other_Comp Object_ID table name : a322_990_comp0dh)
2. (5 points) Count the number of paid Directors, Officers, and Highly Paid Individuals and total by organization, by year.
3. (10 points) For tax year 2015 list the five individuals with the highest total compensation. List from highest to lowest compensation. Include the Name, Role, Organization, Tax Year, and each type of compensation and total compensation for each person on the report. Do not include duplicates of people on the report.
4. (8 points) List the Name, Role, Organization, Tax Year, and Other Compensation for individuals that have only Other compensation, sorted by Other Compensation, from high to low.
5. (5 points) Change the title of the column,"Volunteers" to "Reported_Volunteers".
6. (5 points) For the column "Reported Volunteers" change "null" values to zero.
7. (10 points) It might be interesting to look at what the percentage of Community Benefit Expense (CBE) is relative to Total Expenses for the organization. For 2014 data, make a report for hospitals that computes a ratio of (Community Benefit Expense Amt / Total Expenses) the report should include the tax year, name of the organization, the CBE Amount, Total Expenses, and the computed ratio.
8. (12 points) A reporter might think, correctly or incorrectly, that highly compensated CEOs from hospitals are not concerned with their local communities. For 2016, make a report of the hospitals in the database, listing the hospital name, ein, ceo name (and title) , total compensation, and the community benefit percentage (computed in part 7). Sort the report, low to high, by the community benefit percentage.
9. List the five individuals with the highest total compensation from the database. List from highest to lowest compensation. Include the Name, Role, Organization, Tax Year, and each type of compensation and total compensation for each person on the report. Do not include duplicates of people on the report.