Itemize the Largest Repair Ticket

Problem

An auto repair shop builds tickets out of parts. Table `parts` has `(part_id, rate)` giving each part's price, and table `ticket_lines` has `(ticket_id, part_id, qty)` listing the parts used on each ticket.

Find the ticket whose total cost is the highest, where a ticket's total is the sum over its lines of qty multiplied by rate. If two tickets tie on total cost, choose the one with the smaller `ticket_id`. Then itemize that ticket: for each of its lines, show the part, the quantity, and the line cost (qty times rate).

Return the columns `part_id`, `qty`, and `line_cost`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns part_id, qty, line_cost.

Starter code (SQL)

SELECT *
FROM parts;

Related SQL questions

• 3-Consecutive-Week Marketing StreakHard
• 30-Day Rolling Average Trading VolumeHard
• 7-Day Active User Rolling MetricHard
• 7-Day Revenue Moving AverageHard
• Always Mid-Pack BakersHard
• Annual Energy Output Growth by Panel ModelHard