Table: morningstar_2007_finacom
Columns: event
long_course_short_course
year_set
time
meet

Question: What year had a 100m freestyle event?
SQL: SELECT COUNT("year_set") FROM morningstar_2007_finacom WHERE "event" = '100m freestyle'

Question: What event had a short course in 2010?
SQL: SELECT "event" FROM morningstar_2007_finacom WHERE "long_course_short_course" = 'short course' AND "year_set" = 2010

Question: What year did a short course have a time of 7:51.80?
SQL: SELECT COUNT("year_set") FROM morningstar_2007_finacom WHERE "long_course_short_course" = 'short course' AND "time" = '7:51.80'

Question: What was the latest year that had a 100m freestyle?
SQL: SELECT MAX("year_set") FROM morningstar_2007_finacom WHERE "event" = '100m freestyle'