Table: lega_pro_clubs
Columns: club
city
stadium
capacity
2007_08_season

Question: What 2007-08 season has marcianise as the city?
SQL: SELECT "2007_08_season" FROM lega_pro_clubs WHERE "city" = 'marcianise'

Question: What is the highest capacity that has serie c2/c champions for the 2007-08 season?
SQL: SELECT MAX("capacity") FROM lega_pro_clubs WHERE "2007_08_season" = 'serie c2/c champions'

Question: What is the average capacity that has foligno as the city?
SQL: SELECT AVG("capacity") FROM lega_pro_clubs WHERE "city" = 'foligno'

Question: What is the highest capacity that has stadio marcello torre as the stadium?
SQL: SELECT MAX("capacity") FROM lega_pro_clubs WHERE "stadium" = 'stadio marcello torre'