
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?