ปรากฏล่าสุดของ Suncoast Sound ซึ่งเข้าชิงเกิน 7 ครั้งคือปีใด?
What is the year of most recent appearance of the Suncoast sound, who had more than 7 finals appearances?
df = pd.DataFrame(columns=['year_of_most_recent_appearance', 'corps_name', 'number_of_finals_appearances'])
df.loc[(df['corps_name'] == 'suncoast sound') & (df['number_of_finals_appearances'] > '7'), 'year_of_most_recent_appearance'].count()