Step 1: Select rows where 'party' is not 'total'.
| 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: Order the table by 'total' in ascending order.
| 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 |
Step 3: Select row number 1.
| 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 |
| clann na talmhan |
0 |
2 |
0 |
0 |
1 |
0 |
0 |
0 |
3 |
| labour party |
0 |
0 |
0 |
1 |
5 |
0 |
0 |
2 |
8 |
| fine gael |
1 |
3 |
2 |
2 |
0 |
1 |
0 |
0 |
9 |
| independent |
0 |
1 |
0 |
1 |
0 |
1 |
3 |
3 |
9 |
| fianna fáil |
4 |
4 |
2 |
3 |
0 |
1 |
0 |
7 |
21 |
Step 4: Select rows where 'total' is equal to the 'total' value from step 3.
| 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 |
| clann na talmhan |
0 |
2 |
0 |
0 |
1 |
0 |
0 |
0 |
3 |
Step 5: Select rows where 'total' is equal to the 'total' value from step 3 minus 18.
| 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 |
| clann na talmhan |
0 |
2 |
0 |
0 |
1 |
0 |
0 |
0 |
3 |
Step 6: Use a `CASE` statement to return TRUE if the number of rows from step 4 is equal to the number of rows from step 5, 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 |