SQL: Auction Web Service Lot Winners

Problem Preview

"SQL The auction web service uses a "bid over starting price" model where buyers can increase the starting price of a lot an unlimited number of times with a fixed bid amount predetermined by the seller. The buyer who left the bid last wins. Create a query that returns a list of all available lots with the number of bids, the current lot price, and the current lot winner. The result should have the following columns: name / starting_price / bid_step / bids / current_price / current_winner . * name - lot name * starting_price - lot starting price * bid_step - lot bid step * bids - total number of bids for a specific lot * current_price - current price of the lot, calculated as start_price + (bid_step * number_of_bids) * current_winner - username of the buyer who made the last bid on a specific lot The result should be sorted in ascending order by name. Note: * Some lots may not have bids * Buyers can outbid their own bids despite no competition SCHEMA and OUTUPT Format  "