Question: The company you work for has been doing well recently and wants to hire a lot more employees! It is interested in software developers,

The company you work for has been doing well recently and wants to hire a lot more employees! It is

The company you work for has been doing well recently and wants to hire a lot more employees! It is interested in software developers, particularly senior ones. Data about candidates who successfully passed the recruitment process is saved in the table candidates. create table candidates ( id int primary key, position varchar not null, salary int not null ); Each record in this table contains a unique id for each candidate, their position (which is either "junior" or "senior") and their negotiated salary in dollars per month. Candidates have increasing ids and are sorted in ascending order by salaries. Your company's monthly budget for new employees' salaries is 50,000 dollars. It wants to hire as many senior developers as possible, and then use the remaining money to hire as many junior developers as possible. You were assigned the task of writing a SQL query determining how many employees can be hired for each position. It should return an employees table with two columns: juniors and seniors. The table should contain one row with the number of new employees in each position.

Step by Step Solution

3.39 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

You can use a SQL query to determine how many employees can be hired for each position taking in... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!