Statement: jack nicklaus of the united states has a score of 72 + 70 + 75 + 72 = 289
Input Table: 1975 u.s. open (golf)
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 |
SQL Command:
SELECT
CASE
WHEN COUNT(*) = 0 THEN 'FALSE'
ELSE 'TRUE'
END
FROM table_sql
WHERE player = 'jack nicklaus'
AND country = 'united states'
AND score = '72 + 70 + 75 + 72 = 289';