select l$.$name, min$($o$.$amount$)$ as min$\_$offer, round$($avg$($o$.$amount$),2)$as avg$\_$offer,

max$($o$.$amount$)$ as max$\_$offer, count$($amount$)$as offers from lots l inner join offers o ON

l$.$id$=$o$.$lot$\_$id

ORDER by name

group by offers;