Table: tennis_tournaments_4
Columns: week_of
tournament
champion
runner_up
semifinalists
quarterfinalists

Question: which tournament was the champion nick saviano florin segărceanu 6–3, 6–4?
SQL: SELECT "tournament" FROM tennis_tournaments_4 WHERE "champion" = 'Nick Saviano Florin Segărceanu 6–3, 6–4'

Question: Which tournament was runner-up  paul annacone eric korita?
SQL: SELECT "tournament" FROM tennis_tournaments_4 WHERE "runner_up" = 'Paul Annacone Eric Korita'

Question: Who were the semifinalists when sammy giammalva was  runner-up?
SQL: SELECT "semifinalists" FROM tennis_tournaments_4 WHERE "runner_up" = 'Sammy Giammalva'

Question: which tournament was the champion pat cash 4–6, 6–4, 6–3?
SQL: SELECT "tournament" FROM tennis_tournaments_4 WHERE "champion" = 'Pat Cash 4–6, 6–4, 6–3'

Question: Which tournament was on the week of  24 october and champion is matt doyle 1–6, 6–1, 6–2?
SQL: SELECT "tournament" FROM tennis_tournaments_4 WHERE "week_of" = '24 October' AND "champion" = 'Matt Doyle 1–6, 6–1, 6–2'

Question: How many runner ups were there for the cologne , germany carpet – $75,000 – s32/d16 when the champion was matt doyle 1–6, 6–1, 6–2?
SQL: SELECT COUNT("runner_up") FROM tennis_tournaments_4 WHERE "tournament" = 'Cologne , Germany Carpet – $75,000 – S32/D16' AND "champion" = 'Matt Doyle 1–6, 6–1, 6–2'