Table: roy_scheider_fights
Columns: result
opponent
method
date
round

Question: When did alfonse d'amore compete?
SQL: SELECT "date" FROM roy_scheider_fights WHERE "opponent" = 'alfonse d''amore'

Question: Which Round has a Method of ko, and a Date of 1958?
SQL: SELECT MIN("round") FROM roy_scheider_fights WHERE "method" = 'ko' AND "date" = '1958'

Question: Which Date has a Result of win, and a Round smaller than 2, and an Opponent of myron greenberg?
SQL: SELECT "date" FROM roy_scheider_fights WHERE "result" = 'win' AND "round" < 2 AND "opponent" = 'myron greenberg'

Question: Which Round has a Method of ko, and an Opponent of alfonse d'amore?
SQL: SELECT "round" FROM roy_scheider_fights WHERE "method" = 'ko' AND "opponent" = 'alfonse d''amore'