Step 1: Select rows where 'national_university_of_ireland' is greater than 0.
party |
administrative_panel |
agricultural_panel |
cultural_and_educational_panel |
industrial_and_commercial_panel |
labour_panel |
national_university_of_ireland |
university_of_dublin |
nominated_by_the_taoiseach |
total |
fianna fáil |
4 |
4 |
2 |
3 |
0 |
1 |
0 |
7 |
21 |
fine gael |
1 |
3 |
2 |
2 |
0 |
1 |
0 |
0 |
9 |
labour party |
0 |
0 |
0 |
1 |
5 |
0 |
0 |
2 |
8 |
clann na talmhan |
0 |
2 |
0 |
0 |
1 |
0 |
0 |
0 |
3 |
independent |
0 |
1 |
0 |
1 |
0 |
1 |
3 |
3 |
9 |
total |
7 |
11 |
5 |
9 |
11 |
3 |
3 |
11 |
60 |
Step 2: Select rows where 'fianna fáil' or 'fine gael' are greater than 0.
party |
administrative_panel |
agricultural_panel |
cultural_and_educational_panel |
industrial_and_commercial_panel |
labour_panel |
national_university_of_ireland |
university_of_dublin |
nominated_by_the_taoiseach |
total |
fianna fáil |
4 |
4 |
2 |
3 |
0 |
1 |
0 |
7 |
21 |
fine gael |
1 |
3 |
2 |
2 |
0 |
1 |
0 |
0 |
9 |
independent |
0 |
1 |
0 |
1 |
0 |
1 |
3 |
3 |
9 |
total |
7 |
11 |
5 |
9 |
11 |
3 |
3 |
11 |
60 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 2, otherwise return FALSE.
party |
administrative_panel |
agricultural_panel |
cultural_and_educational_panel |
industrial_and_commercial_panel |
labour_panel |
national_university_of_ireland |
university_of_dublin |
nominated_by_the_taoiseach |
total |
fianna fáil |
4 |
4 |
2 |
3 |
0 |
1 |
0 |
7 |
21 |
fine gael |
1 |
3 |
2 |
2 |
0 |
1 |
0 |
0 |
9 |
Prediction: TRUE