Table: group_winners
Columns: season
group_a_winner
group_b_winner
group_c_winner
group_d_winner

Question: What is the number of group b winner for francavilla?
SQL: SELECT COUNT("group_b_winner") FROM group_winners WHERE "group_c_winner" = 'Francavilla'

Question: What is the group a winner for modena?
SQL: SELECT "group_a_winner" FROM group_winners WHERE "group_b_winner" = 'Modena'

Question: What is the group a winner for vis pesaro?
SQL: SELECT "group_a_winner" FROM group_winners WHERE "group_c_winner" = 'Vis Pesaro'

Question: What group a winner was for nocerina?
SQL: SELECT "group_a_winner" FROM group_winners WHERE "group_d_winner" = 'Nocerina'

Question: What was the group d winner for modena?
SQL: SELECT "group_d_winner" FROM group_winners WHERE "group_b_winner" = 'Modena'