Table: inter_cardiff_sponsorship
Columns: sponsored_name
non_sponsored_name
sponsor
stadium
city
country
sport
sponsorship_ended

Question: What is the last year a sponsorship ended?
SQL: SELECT MAX("sponsorship_ended") FROM inter_cardiff_sponsorship

Question: How many countries played in the city of ljungskile?
SQL: SELECT COUNT("country") FROM inter_cardiff_sponsorship WHERE "city" = 'Ljungskile'

Question: What cities are in sweden on this list?
SQL: SELECT "city" FROM inter_cardiff_sponsorship WHERE "country" = 'Sweden'

Question: What country is new orleans in?
SQL: SELECT "country" FROM inter_cardiff_sponsorship WHERE "city" = 'New Orleans'

Question: What country are the new orleans shell shockers from?
SQL: SELECT "country" FROM inter_cardiff_sponsorship WHERE "sponsored_name" = 'New Orleans Shell Shockers'