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 .
The result should be sorted in ascending order by name.
Note:
SCHEMA and OUTUPT Format


IndiaMART • Pending
Amazon • Pending
Amazon • Pending
Code with cisco - CwC 26 • Pending
Code with cisco - CwC 26 • Pending