Step 1: Order the table by 'crowd' in descending order.
| home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
| footscray |
14.7 (91) |
st kilda |
9.11 (65) |
western oval |
18655 |
1972-07-15 |
| fitzroy |
16.14 (110) |
north melbourne |
9.12 (66) |
junction oval |
7007 |
1972-07-15 |
| essendon |
13.12 (90) |
richmond |
17.9 (111) |
windy hill |
22251 |
1972-07-15 |
| carlton |
20.8 (128) |
south melbourne |
8.15 (63) |
princes park |
14465 |
1972-07-15 |
| hawthorn |
19.14 (128) |
geelong |
15.8 (98) |
glenferrie oval |
12425 |
1972-07-15 |
| collingwood |
10.13 (73) |
melbourne |
8.10 (58) |
vfl park |
30883 |
1972-07-15 |
Step 2: Select rows where 'home_team' is 'fitzroy' and 'away_team' is 'north melbourne'.
| home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
| collingwood |
10.13 (73) |
melbourne |
8.10 (58) |
vfl park |
30883 |
1972-07-15 |
| essendon |
13.12 (90) |
richmond |
17.9 (111) |
windy hill |
22251 |
1972-07-15 |
| footscray |
14.7 (91) |
st kilda |
9.11 (65) |
western oval |
18655 |
1972-07-15 |
| carlton |
20.8 (128) |
south melbourne |
8.15 (63) |
princes park |
14465 |
1972-07-15 |
| hawthorn |
19.14 (128) |
geelong |
15.8 (98) |
glenferrie oval |
12425 |
1972-07-15 |
| fitzroy |
16.14 (110) |
north melbourne |
9.12 (66) |
junction oval |
7007 |
1972-07-15 |
Step 3: Select rows where 'home_team' is 'essendon' and 'away_team' is 'richmond'.
| home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
| fitzroy |
16.14 (110) |
north melbourne |
9.12 (66) |
junction oval |
7007 |
1972-07-15 |
Step 4: Use a `CASE` statement to return TRUE if the number of rows for the fitzroy vs north melbourne game is greater than the number of rows for the essendon vs richmond game, otherwise return FALSE.
| home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |