Exercise #7

Using the provided sample database, since 2010, to date (meaning no future shows considered), use SQL queries to determine the following:

  • What date, band and location was my first show in 2015?
  • How many different bands have I played a show with?
  • Show date, band, venue, city and state for all shows have I played in Oregon.
  • Show date, band, venue, city and state for all shows have I played in Winnemucca.
  • Show date, band, venue, city and state for all shows I played with Bill Kirchen.
  • List all the venues have I played in California.
  • What year did I play the most shows?
  • What year did I play the fewest shows?
  • What band have I played the most shows with?
  • What venue have I played the most?
  • How many private events have I played?

Show your queries along with results.