Exam DISC-DA Practice Question 16
Study guide: Exam DISC-DA
A policy table has 1,000 rows, each with a unique policy_id. A claim table has 150 rows: 145 claims on 120 distinct policies that are in the policy table, and 5 orphan claims whose policy_id is not in the policy table. How many rows does this query return?
SELECT *
FROM policy p
LEFT JOIN claim c ON p.policy_id = c.policy_id;
- A) 1,000
- B) 1,025
- C) 1,030
- D) 1,150
Answer this question and see the worked solution