Exam DISC-DA Practice Question 18
Study guide: Exam DISC-DA
A policy table holds four policies with deductibles of 500, 1,000, NULL and 1,500. The underwriting manager wants the average deductible with an unrecorded deductible counted at the company's $500 default. Which expression returns that figure?
- A)
AVG(COALESCE(deductible, 500)) - B)
AVG(deductible) - C)
COALESCE(AVG(deductible), 500) - D)
SUM(deductible) / COUNT(deductible)
Answer this question and see the worked solution