Step 1: Select rows where 'position' is 'prop'.
| player |
position |
date_of_birth__age_ |
caps |
club___province |
| george chuter |
hooker |
1976-07-09 |
19 |
leicester |
| lee mears |
hooker |
1979-03-05 |
18 |
bath |
| mark regan |
hooker |
1972-01-28 |
43 |
bristol |
| jason hobson |
prop |
1983-02-10 |
0 |
bristol |
| tim payne |
prop |
1979-04-29 |
5 |
wasps |
| andrew sheridan |
prop |
1979-11-01 |
20 |
sale |
| matt stevens |
prop |
1982-10-01 |
20 |
bath |
| phil vickery ( c ) |
prop |
1976-03-14 |
60 |
wasps |
| steve borthwick |
lock |
1979-10-12 |
32 |
bath |
| louis deacon |
lock |
1980-10-07 |
6 |
leicester |
| ben kay |
lock |
1975-12-14 |
53 |
leicester |
| simon shaw |
lock |
1973-09-01 |
43 |
wasps |
| tom croft |
flanker |
1985-11-07 |
0 |
leicester |
| james haskell |
flanker |
1985-04-02 |
2 |
wasps |
| michael lipman |
flanker |
1980-01-16 |
0 |
bath |
| magnus lund |
flanker |
1983-06-25 |
10 |
sale |
| lewis moody |
flanker |
1978-06-12 |
52 |
leicester |
| tom rees |
flanker |
1984-09-11 |
8 |
wasps |
| joe worsley |
flanker |
1977-06-14 |
65 |
wasps |
| nick easter |
number 8 |
1978-08-15 |
12 |
harlequins |
| luke narraway |
number 8 |
1983-09-07 |
0 |
gloucester |
| danny care |
scrum - half |
1987-01-02 |
0 |
harlequins |
| lee dickson |
scrum - half |
1985-03-29 |
0 |
newcastle |
| andy gomarsall |
scrum - half |
1974-07-24 |
33 |
harlequins |
| paul hodgson |
scrum - half |
1982-04-25 |
0 |
london irish |
| peter richards |
scrum - half |
1978-03-10 |
12 |
london irish |
| richard wigglesworth |
scrum - half |
1983-06-09 |
0 |
sale |
| danny cipriani |
fly - half |
1987-11-02 |
0 |
wasps |
| shane geraghty |
fly - half |
1986-08-12 |
2 |
london irish |
| charlie hodgson |
fly - half |
1980-11-12 |
29 |
sale |
| jonny wilkinson |
fly - half |
1979-05-25 |
65 |
newcastle |
| toby flood |
centre |
1985-08-01 |
12 |
newcastle |
| jamie noon |
centre |
1979-05-09 |
27 |
newcastle |
| mathew tait |
centre |
1986-02-06 |
19 |
newcastle |
| mike tindall |
centre |
1978-10-18 |
54 |
gloucester |
| paul sackey |
wing |
1979-11-08 |
10 |
wasps |
| james simpson - daniel |
wing |
1982-05-30 |
10 |
gloucester |
| david strettle |
wing |
1983-07-23 |
3 |
harlequins |
| lesley vainikolo |
wing |
1979-05-04 |
5 |
gloucester |
| iain balshaw |
fullback |
1979-04-14 |
30 |
gloucester |
| mark cueto |
fullback |
1979-12-26 |
24 |
sale |
Step 2: Select rows where 'club___province' is 'leicester'.
| player |
position |
date_of_birth__age_ |
caps |
club___province |
| jason hobson |
prop |
1983-02-10 |
0 |
bristol |
| tim payne |
prop |
1979-04-29 |
5 |
wasps |
| andrew sheridan |
prop |
1979-11-01 |
20 |
sale |
| matt stevens |
prop |
1982-10-01 |
20 |
bath |
| phil vickery ( c ) |
prop |
1976-03-14 |
60 |
wasps |
Step 3: Select rows where 'player' is 'steve borthwick'.
| player |
position |
date_of_birth__age_ |
caps |
club___province |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
| player |
position |
date_of_birth__age_ |
caps |
club___province |
| verification_result |
| FALSE |