SQL Quiz
10 questions · no time limit
0:00
DATA QUALITY AND DEBUGGING
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
An analyst needs the arithmetic mean of employee completion rates, giving each employee equal weight. The integer columns are
completed_tasks and assigned_tasks, and employees with zero assigned tasks should be excluded from the average. The current expression is CAST(AVG(completed_tasks / NULLIF(assigned_tasks, 0)) AS DECIMAL(8,4)).Which replacement preserves each employee's fractional rate before
AVG is evaluated? YOUR PROGRESS
10
QUESTIONS
Ready when you are
Answer in any order. Your progress shows here as you go.
QUESTIONS
KEYBOARD
Pick an answer ABCD
Next question ↵→
Previous ←
Flag for review F
Answers save as you go · flagged questions come back at the end