Statement: the attendance in week 12 was higher than the attendance in week 6 and 13
Input Table: 1976 buffalo bills season
week | date | opponent | result | attendance |
1 | 1976-09-13 | miami dolphins | l 30 - 21 | 77683 |
2 | 1976-09-19 | houston oilers | l 13 - 3 | 61384 |
3 | 1976-09-26 | tampa bay buccaneers | w 14 - 9 | 44505 |
4 | 1976-10-03 | kansas city chiefs | w 50 - 17 | 51909 |
5 | 1976-10-10 | new york jets | l 17 - 14 | 59110 |
6 | 1976-10-17 | baltimore colts | l 31 - 13 | 71009 |
7 | 1976-10-24 | new england patriots | l 26 - 22 | 45144 |
8 | 1976-10-31 | new york jets | l 19 - 14 | 41285 |
9 | 1976-11-07 | new england patriots | l 20 - 10 | 61157 |
10 | 1976-11-15 | dallas cowboys | l 17 - 10 | 51799 |
11 | 1976-11-21 | san diego chargers | l 34 - 13 | 36539 |
12 | 1976-11-25 | detroit lions | l 27 - 14 | 66875 |
13 | 1976-12-05 | miami dolphins | l 45 - 27 | 43475 |
14 | 1976-12-12 | baltimore colts | l 58 - 20 | 50451 |
SQL Command:
SELECT
CASE
WHEN (SELECT attendance FROM table_sql WHERE week = 12) >
(SELECT attendance FROM table_sql WHERE week = 6) AND
(SELECT attendance FROM table_sql WHERE week = 12) >
(SELECT attendance FROM table_sql WHERE week = 13)
THEN 'TRUE'
ELSE 'FALSE'
END;