国产精品天干天干,亚洲毛片在线,日韩gay小鲜肉啪啪18禁,女同Gay自慰喷水

歡迎光臨散文網(wǎng) 會員登陸 & 注冊

database_leetcode 2004. The Number of Seniors and Juniors to Joi

2022-02-22 14:02 作者:您是打尖兒還是住店呢  | 我要投稿

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)鍵就是最后一句話;

database_leetcode 2004. The Number of Seniors and Juniors to Joi的評論 (共 條)

分享到微博請遵守國家法律
吉木乃县| 盐边县| 龙陵县| 云霄县| 永兴县| 濮阳县| 界首市| 浮梁县| 平湖市| 北宁市| 容城县| 岗巴县| 张家界市| 嫩江县| 左云县| 安西县| 清新县| 海安县| 麻阳| 苍梧县| 罗源县| 迁安市| 华宁县| 安丘市| 叶城县| 临朐县| 凭祥市| 武安市| 衡山县| 临洮县| 宿松县| 剑川县| 大庆市| 洪江市| 苗栗市| 靖江市| 乐山市| 和平区| 政和县| 衡阳县| 马尔康县|