Step 1: Select rows where 'district' is 'bhind'.
constituency_number |
name |
reserved_for___sc___st___none |
district |
number_of_electorates__2009 |
9 |
ater |
none |
bhind |
177334 |
10 |
bhind |
none |
bhind |
197183 |
11 |
lahar |
none |
bhind |
205839 |
12 |
mehgaon |
none |
bhind |
210649 |
13 |
gohad |
sc |
bhind |
166893 |
20 |
sewda |
none |
datia |
130161 |
21 |
bhander |
sc |
datia |
139600 |
22 |
datia |
none |
datia |
143593 |
total : |
total : |
total : |
total : |
1371252 |
Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to 5, otherwise return FALSE.
constituency_number |
name |
reserved_for___sc___st___none |
district |
number_of_electorates__2009 |
9 |
ater |
none |
bhind |
177334 |
10 |
bhind |
none |
bhind |
197183 |
11 |
lahar |
none |
bhind |
205839 |
12 |
mehgaon |
none |
bhind |
210649 |
13 |
gohad |
sc |
bhind |
166893 |
Prediction: TRUE