Isn ' t that very mildly exaggerated ? <| sep |> have each price multiplied by the number of tickets sold at that price and then added for the total amount per eventcode SELECT ticket . eventcode , SUMsub . pricesubtotal AS pricetotal , MINticket . showdate AS firstshowdate , MAXticket . showdate AS lastshowdate FROM SELECT eventcode , COUNT price AS pricesubtotal FROM ticket GROUP BY eventcode , price AS sub INNER JOIN ticket ON ticket . eventcode sub . eventcode GROUP BY ticket . eventcode <| sep |> Intellij idea is awesome and a real step up from eclipse <| sep |> Is that English ? <| sep |> when there are so many good socialist countries like Norway , Sweden , Denmark , etc . None of those are fucking socialist . <| sep |> THIS MAKES ME SO HAPPY I CAN ' T EVEN