Exam DISC-DA Practice Question 13

Study guide: Exam DISC-DA

An analyst needs the territories whose accident year 2024 claims have total paid losses over $1,000,000. The query already has FROM claim, WHERE acc_year = 2024 and GROUP BY terr. Where must the condition SUM(paid) > 1000000 go?

• A) In the WHERE clause, joined to the accident year condition with AND
• B) In the ORDER BY clause, so that the largest territories sort first
• C) In the SELECT list, given a name with a column alias
• D) In a HAVING clause, which is applied after the grouping

Answer this question and see the worked solution

Concepts tested

• SQL

More questions from this set

• Exam DISC-DA Practice Question 12
• Exam DISC-DA Practice Question 14