Statement: united states has a 69 + 73 + 72 + 75 = 289 score

Input Table: 1975 u.s. open (golf)

Step 1: Select rows where 'country' is 'united states'.

place	player	country	score	to_par	money
t1	lou graham	united states	74 + 72 + 68 + 73 = 287	+ 3	playoff
t1	john mahaffey	united states	73 + 71 + 72 + 71 = 287	+ 3	playoff
t3	frank beard	united states	74 + 69 + 67 + 78 = 288	+ 4	10875
t3	ben crenshaw	united states	70 + 68 + 76 + 74 = 288	+ 4	10875
t3	hale irwin	united states	74 + 71 + 73 + 70 = 288	+ 4	10875
t3	bob murphy	united states	74 + 73 + 72 + 69 = 288	+ 4	10875
t7	jack nicklaus	united states	72 + 70 + 75 + 72 = 289	+ 5	7500
t7	peter oosterhuis	england	69 + 73 + 72 + 75 = 289	+ 5	7500
t9	pat fitzsimons	united states	67 + 73 + 73 + 77 = 290	+ 6	5000
t9	arnold palmer	united states	69 + 75 + 73 + 73 = 290	+ 6	5000
t9	tom watson	united states	67 + 68 + 78 + 77 = 290	+ 6	5000

Step 2: Extract the numerical score from the 'score' column then add column 'num_score' to existing table.

place	player	country	score	to_par	money
t1	lou graham	united states	74 + 72 + 68 + 73 = 287	+ 3	playoff
t1	john mahaffey	united states	73 + 71 + 72 + 71 = 287	+ 3	playoff
t3	frank beard	united states	74 + 69 + 67 + 78 = 288	+ 4	10875
t3	ben crenshaw	united states	70 + 68 + 76 + 74 = 288	+ 4	10875
t3	hale irwin	united states	74 + 71 + 73 + 70 = 288	+ 4	10875
t3	bob murphy	united states	74 + 73 + 72 + 69 = 288	+ 4	10875
t7	jack nicklaus	united states	72 + 70 + 75 + 72 = 289	+ 5	7500
t9	pat fitzsimons	united states	67 + 73 + 73 + 77 = 290	+ 6	5000
t9	arnold palmer	united states	69 + 75 + 73 + 73 = 290	+ 6	5000
t9	tom watson	united states	67 + 68 + 78 + 77 = 290	+ 6	5000

Step 3: Select rows where 'num_score' is 289.

place	player	country	score	to_par	money	num_score
t1	lou graham	united states	74 + 72 + 68 + 73 = 287	+ 3	playoff	287
t1	john mahaffey	united states	73 + 71 + 72 + 71 = 287	+ 3	playoff	287
t3	frank beard	united states	74 + 69 + 67 + 78 = 288	+ 4	10875	288
t3	ben crenshaw	united states	70 + 68 + 76 + 74 = 288	+ 4	10875	288
t3	hale irwin	united states	74 + 71 + 73 + 70 = 288	+ 4	10875	288
t3	bob murphy	united states	74 + 73 + 72 + 69 = 288	+ 4	10875	288
t7	jack nicklaus	united states	72 + 70 + 75 + 72 = 289	+ 5	7500	289
t9	pat fitzsimons	united states	67 + 73 + 73 + 77 = 290	+ 6	5000	290
t9	arnold palmer	united states	69 + 75 + 73 + 73 = 290	+ 6	5000	290
t9	tom watson	united states	67 + 68 + 78 + 77 = 290	+ 6	5000	290

Step 4: Use a `CASE` statement to return TRUE if the number of rows is greater than or equal to 1, otherwise return FALSE.

place	player	country	score	to_par	money	num_score
t7	jack nicklaus	united states	72 + 70 + 75 + 72 = 289	+ 5	7500	289