Write a query that returns a list of all available lots with the number of bids.
Use the provided lots and bids tables. Include available lots that have received no bids, and exclude unavailable lots.
lot_id, lot_name, and bid_count.lot_id ascending.| Column | Type | Description |
|---|---|---|
| lot_idPK | INT | Unique identifier for the lot |
| lot_name | VARCHAR(100) | Display name of the lot |
| is_available | BOOLEAN | Whether the lot is currently available |
| Column | Type | Description |
|---|---|---|
| bid_idPK | INT | Unique identifier for the bid |
| lot_id | INT | Lot receiving the bid |
| bidder_name | VARCHAR(100) | Name of the bidder |