Ultimate access to all questions.
A broadband company uses a delta table named bills
with Change Data Feed enabled to store the latest bills of all customers. The table is updated whenever a new bill is generated, with only the bill_date
and amount
columns being updated for existing customers. If a customer leaves the company, their bill details are deleted from the bills
table. Which query should be used to retrieve the list of all customers along with the details of their first-ever bill?