1. Assuming (1) Attrition = Total Terminations / Headcount and (2) Headcount = 100. Write a single query to calculate attrition for all former associates in the termination table.

2. Assuming (1) Attrition = Total Terminations / Headcount and (2) Headcount = 35. Write a single query to calculate attrition for former associates in Information Technology.

3. Write a query combining the employee table with the position table to determine open positions.

4. Write a query to display a single hire and termination roster for all hires and terminations including the fields: employee_id, first_name, last_name, employment_status, and effective_date.

5. Using the SQL Query and Notes fields define a table or multiple tables you would create to store data on a company's recruiting process including table names, field names, and anything else you think would be relevant.

Table Name emplovee id tenure in vears hire date Employee first name 1234 Sheri 1235 Ryan 1236 Farone 1237 Deeksha 1238 Mary 1239 Tarik last name Smith Doe Mars Than Peters Kidder emplovee type 5.2 Full 0.6 Part_time 4 Full 0.4 Intern 3.5 Full 7 Full 4/1/15 1/20/20 7/5/16 2/4/20 2/25/17 7/1/13 Table Name employee id term date Termination first name 1225 Tom 1226 Eddie 1227 Ankita 1228 Marcela 1229 Niki 1230 Sam last name Frame Mats Langhorne Logan Dupont Plenn business unit 4/1/15 Human Resources 6/15/19 Information Technology 7/5/16 Information Technology 2/4/20 Sales 2/25/17 Sales 7/1/13 Human Resources term_reason Voluntary Involuntary Voluntary Voluntary Voluntary Involuntary Table Name positionid employee id Position title R4567 Director People Analytics R4568 Analytics Analyst R4570 Analytics Manager R4571 Data Consultant R4572 Senior Data Consultant R4573 Data Engineer R4574 Junior Data Engineer R4575 Database Administrator R4576 Report Analyst job category Manager Analytics Analytics Analytics Manager Engineering Engineering Engineering Analytics business unit Human Resources Information Technology Sales Information Technology Human Resources Information Technology Information Technology Information Technology Human Resources mgmt level 1234 1238 1236 1241 1242 1239 1237 1243 1235 135 105 110 120 130 120 110 110 105