Table: drum_corps_finalists
Columns: corps_name
number_of_finals_appearances
year_of_first_appearance
year_of_most_recent_appearance
all_years_of_finals_appearances

Question: What is the average year of the most recent appearance of the Boston Crusaders, who had their first appearance after 1976?
SQL: SELECT AVG("year_of_most_recent_appearance") FROM drum_corps_finalists WHERE "year_of_first_appearance" > 1976 AND "corps_name" = 'boston crusaders'

Question: What is the year of most recent appearance of the Suncoast sound, who had more than 7 finals appearances?
SQL: SELECT COUNT("year_of_most_recent_appearance") FROM drum_corps_finalists WHERE "corps_name" = 'suncoast sound' AND "number_of_finals_appearances" > 7

Question: What is the year of the first appearance of the Black Knights, who had less than 1 finals appearances?
SQL: SELECT COUNT("year_of_first_appearance") FROM drum_corps_finalists WHERE "corps_name" = 'black knights' AND "number_of_finals_appearances" < 1