/*This SQL script uses the Demo database.

  This sample illustrates use of SUM function.
  The query retrieves sum of ticket prices for every venue.*/

select VenueNo, Sum(Ticket_Price) as Total from events
group by VenueNo

