/*This SQL script uses the Demo database.
  This sample illustrates use of AVG function.
  The query retrieves average ticket price for every venue.*/

select VenueNo, Avg(Ticket_Price) from events
group by VenueNo

