subject

On an online recruiting platform, each recruiting company can make a request for their candidates to complete a personalized skill assessment. The assessment can contain tasks in three categories: SQL, Algo and BugFixing. Following the assessment, the company receives a report containing, for each candidate, their declared years of experience (an integer between 0 and 100) and their score in each category. The score is the number of points from 0 to 100, or NULL, which means there was no task in this category. You are given a table, assessments, with the following structure: create table assessments ( id integer not null, experience integer not null, sql integer, algo integer, bug_fixing integer, unique(id) ); Your task is to write an SQL query that, for each different length of experience, counts the number of candidates with precisely that amount of experience and how many of them got a perfect score in each category in which they were requested to solve tasks (so a NULL score is here treated as a perfect score). Your query should return a table containing the following columns: exp (each candidate's years of experience), max (number of assessments achieving the maximum score), count (total number of assessments). Rows should be ordered by decreasing exp.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 16:00
If a client wants to make minor edits, what should he/she use?
Answers: 3
question
Computers and Technology, 23.06.2019 04:20
4. a1. vince owns a television repair shop that is insured undera commercial package policy. the policy includes thebuilding and personal property coverage form and thecauses-of-loss broad form. the declarations page indicatesthat coverage applies to both the building and the namedinsured's business property. explain whether or not thefollowing losses would be covered under his policy.a. a fire occurs on the premises, and the building isbadly damaged.b. a burglar steals some money and securities from anunlocked safe.c. a business computer is damaged by vandals whobreak into the shop after business hours.d. a tornado touches down near the store. several tel-evision sets of customers in the shop for repair aredamaged in the storm.til
Answers: 2
question
Computers and Technology, 24.06.2019 09:50
Self contained sequences of actions to be performed are? a. expressions b. algorithms c. functions d. formulas
Answers: 1
question
Computers and Technology, 24.06.2019 18:00
Which of the following is an example of synchronous communication? a) e-mail b) voicemail c) telephone conversation d) text message.
Answers: 1
You know the right answer?
On an online recruiting platform, each recruiting company can make a request for their candidates to...
Questions
question
Social Studies, 06.12.2020 07:30
question
Health, 06.12.2020 07:30
question
Mathematics, 06.12.2020 07:30
question
Spanish, 06.12.2020 07:30
question
Chemistry, 06.12.2020 07:30
question
Mathematics, 06.12.2020 07:40
question
Mathematics, 06.12.2020 07:40
Questions on the website: 13722367