You Have a Database That Contains Information About All of the Employees

question 7

Essay

You have a database that contains information about all of the employees from your company.  There is a table containing basic demographic information called Employees and a table containing salary information called Pay. The two tables are related by the field called Emp ID.
Your supervisor wants to see a list of employees who are making over $25,000.00 and have a last name of a "Wilson". Describe how to accomplish this.

---

Definitions:

MAGI

MAGI stands for Modified Adjusted Gross Income, a measure used in the U.S. tax code to determine eligibility for certain tax benefits by modifying the adjusted gross income with specific additions or deductions.

Net Investment Income

The income received from investment assets (like stocks, bonds, mutual funds) after deducting related expenses.

Surtax

An additional tax levied on top of the base tax liability; often applied to income exceeding a certain threshold.

Tax Rates

The percentage at which an individual or corporation is taxed, varying based on income level.