Statement: fred couples had a score larger than 210
Input Table: 1988 u.s. open (golf)
place | player | country | score | to_par |
1 | curtis strange | united states | 70 + 67 + 69 = 206 | - 7 |
t2 | nick faldo | england | 72 + 67 + 68 = 207 | - 6 |
t2 | bob gilder | united states | 68 + 69 + 70 = 207 | - 6 |
t2 | scott simpson | united states | 69 + 66 + 72 = 207 | - 6 |
t5 | larry mize | united states | 69 + 67 + 72 = 208 | - 5 |
t5 | d a weibring | united states | 71 + 69 + 68 = 208 | - 5 |
7 | mark o'meara | united states | 71 + 72 + 66 = 209 | - 4 |
8 | fred couples | united states | 72 + 67 + 71 = 210 | - 3 |
9 | lanny wadkins | united states | 70 + 71 + 70 = 211 | - 2 |
10 | ken green | united states | 72 + 70 + 70 = 212 | - 1 |
SQL Command:
SELECT
CASE
WHEN (SELECT score FROM table_sql WHERE player = 'fred couples') > 210
THEN 'TRUE'
ELSE 'FALSE'
END;