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, 23.06.2019 16:00
Write a grading program for a class with the following grading policies: a. there are two quizzes, each graded on the basis of 10 points. b. there is one midterm exam and one final exam, each graded on the basis of 100 points. c. the final exam counts for 50% of the grade, the midterm counts for 25%, and the two quizzes together count for a total of 25%. (do not forget to normalize the quiz scores. they should be converted to a percentage before they are averaged in.) any grade of 90 or more is an a, any grade of 80 or more (but less than 90) is a b, any grade of 70 or more (but less than 80) is a c, any grade of 60 or more (but less than 70) is a d, and any grade below 60 is an f. the program will read in the student’s scores and output the student’s record, which consists of two quiz and two exam scores as well as the student’s average numeric score for the entire course and final letter grade. define and use a structure for the student reco
Answers: 2
question
Computers and Technology, 23.06.2019 20:30
What is the biggest difference between section breaks and regular page breaks
Answers: 1
question
Computers and Technology, 23.06.2019 21:00
Which set of steps will organize the data to only show foods with more than 100 calories and rank their sugar content from greatest to least?
Answers: 1
question
Computers and Technology, 23.06.2019 21:20
In microsoft word, when you highlight existing text you want to replace, you're in              a.  advanced mode.    b.  automatic mode.    c.  basic mode.    d.  typeover mode
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
Mathematics, 26.10.2020 05:10
question
Social Studies, 26.10.2020 05:10
question
Mathematics, 26.10.2020 05:10
Questions on the website: 13722360