Step 1: Select rows where 'settlement' is 'titel' or 'lok'.
settlement |
cyrillic_name |
type |
population__2011 |
largest_ethnic_group__2002 |
dominant_religion__2002 |
titel |
тител |
town |
5294 |
serbs |
orthodox christianity |
gardinovci |
гардиновци |
village |
1297 |
serbs |
orthodox christianity |
lok |
лок |
village |
1114 |
serbs |
orthodox christianity |
mošorin |
мошорин |
village |
2569 |
serbs |
orthodox christianity |
šajkaš |
шајкаш |
village |
4374 |
serbs |
orthodox christianity |
Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to 2, otherwise return FALSE.
settlement |
cyrillic_name |
type |
population__2011 |
largest_ethnic_group__2002 |
dominant_religion__2002 |
titel |
тител |
town |
5294 |
serbs |
orthodox christianity |
lok |
лок |
village |
1114 |
serbs |
orthodox christianity |
Prediction: TRUE