Tax exempt entities exist for the public good; by law, their tax returns, IRS Form 990, are made publicly available from

[answerhappygod]

Tax exempt entities exist for the public good; by law, their tax
returns, IRS Form 990, are made publicly available from the
Internal Revenue Service. This availability provides transparencey
and scrutiny by the public and private sectors. Form 990 is the
most complete set of data available to analyze non-profits.
Compensation data, within the Form 990 is arguably the most
looked-at information in the nonprofit world. Reporters,
individuals, competing organizations, unions, and the IRS routinely
look at, analyze, and report this information.
Compensation can be an important metric when comparing
organizations. The tax returns of for-profit organizations are
confidential - and are not publicly disclosed by the IRS. Because
it is publicly available, the Form 990 is the only data set where
many questions can be analyzed. The following questions consider
compensation, and other items from a small sample of Form 990
returns.
Using SQLite, and the database provided (990Case), create SQL
commands to provide the information requested below. Screen-shot
the report, or other information, as evidence of the completion of
each of the tasks.
(5 points) Create 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.
(5 points) Count the number of paid Directors, Officers, and
Highly Paid Individuals and total by organization, by year.
(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.
(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 points) Change the title of the column,"Volunteers" to
"Reported_Volunteers".
(5 points) For the column "Reported Volunteers" change "null"
values to zero.
(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, create 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.
(12 points) A reporter might think, correctly or incorrectly,
that highly compensated CEOs from hospitals are not concerned with
their local communities. For 2016, create 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 re