You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_name_42 (winning_score VARCHAR, runner_s__up VARCHAR, margin_of_victory VARCHAR)
system
What was the winning score when the runner-up was Beth Daniel and the margin of victory was 7 strokes?
user
SELECT winning_score FROM table_name_42 WHERE runner_s__up = "beth daniel" AND margin_of_victory = "7 strokes"
assistant
<|im_start|>system
You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_name_42 (winning_score VARCHAR, runner_s__up VARCHAR, margin_of_victory VARCHAR)<|im_end|>
<|im_start|>user
What was the winning score when the runner-up was Beth Daniel and the margin of victory was 7 strokes?<|im_end|>
