Table: Candidates

+-------------+------+

| Column Name | Type |

+-------------+------+

| employee_id | int ?|

| experience ?| enum |

| salary ? ? ?| int ?|

+-------------+------+

employee_id is the primary key column for this table.

experience is an enum with one of the values ('Senior', 'Junior').

Each row of this table indicates the id of a candidate, their monthly salary, and their experience.

A company wants to hire new employees. The budget of the company for the salaries is $70000. The company's criteria for hiring are:

Hiring the largest number of seniors.

After hiring the maximum number of seniors, use the remaining budget to hire the largest number of juniors.

Write an SQL query to find the number of seniors and juniors hired under the mentioned criteria.

Return the result table in any order.

Candidates table:

+-------------+------------+--------+

| employee_id | experience | salary |

+-------------+------------+--------+

| 1 ? ? ? ? ? | Junior ? ? | 10000 ?|

| 9 ? ? ? ? ? | Junior ? ? | 10000 ?|

| 2 ? ? ? ? ? | Senior ? ? | 80000 ?|

| 11 ? ? ? ? ?| Senior ? ? | 80000 ?|

| 13 ? ? ? ? ?| Senior ? ? | 80000 ?|

| 4 ? ? ? ? ? | Junior ? ? | 40000 ?|

+-------------+------------+--------+

Output:

+------------+---------------------+

| experience | accepted_candidates |

+------------+---------------------+

| Senior ? ? | 0 ? ? ? ? ? ? ? ? ? |

| Junior ? ? | 3 ? ? ? ? ? ? ? ? ? |

+------------+---------------------+

Explanation:

We cannot hire any seniors with the current budget as we need at least $80000 to hire one senior.

We can hire all three juniors with the remaining budget.

其實(shí)關(guān)鍵就是最后一句話；