SQL · Squarepoint · Medium
Problem You have three tables that track an auction system: buyers, lots, and bids. For every lot, you need to report its name, starting price, total number of bids received, the current price computed as starting_price + bid_step * number_of_bids, and the username of the current winner. The current winner is the buyer who placed the bid with the latest time for that lot. Lots that have not received any bids should still appear in the output, showing a bid count of 0 and a…
Checking your access…