Statement: the coquitlam adanacs have made 1177 points over 45 seasons

Input Table: coquitlam adanacs

Step 1: Select rows where 'team_name' is 'coquitlam adanacs'.
season team_name games losses points
1965 coquitlam adanacs 30 18 24
1966 coquitlam adanacs 30 11 38
1967 coquitlam adanacs 30 15 29
1968 portland adanacs 38 14 48
1969 coquitlam adanacs 29 3 52
1970 coquitlam adanacs 30 16 28
1971 coquitlam adanacs 31 12 37
1972 coquitlam adanacs 36 23 18
1973 coquitlam adanacs 25 9 32
1974 coquitlam adanacs 24 15 17
1975 coquitlam adanacs 24 16 16
1976 coquitlam adanacs 24 15 18
1977 coquitlam adanacs 24 13 22
1978 coquitlam adanacs 24 13 21
1979 coquitlam adanacs 30 12 35
1980 coquitlam adanacs 24 9 30
1981 coquitlam adanacs 24 7 34
1982 coquitlam adanacs 24 16 16
1983 coquitlam adanacs 24 14 20
1984 coquitlam adanacs 24 14 20
1985 coquitlam adanacs 24 10 28
1986 coquitlam adanacs 24 14 20
1987 coquitlam adanacs 24 11 26
1988 coquitlam adanacs 24 11 26
1989 coquitlam adanacs 24 13 22
1990 coquitlam adanacs 24 18 12
1991 coquitlam adanacs 24 6 36
1992 coquitlam adanacs 24 14 20
1993 coquitlam adanacs 23 6 34
1994 coquitlam adanacs 20 7 26
1995 coquitlam adanacs 25 11 25
1996 coquitlam adanacs 20 15 10
1997 coquitlam adanacs 20 10 19
1998 coquitlam adanacs 25 9 31
1999 coquitlam adanacs 25 7 36
2000 coquitlam adanacs 25 11 28
2001 coquitlam adanacs 20 8 24
2002 coquitlam adanacs 20 6 27
2003 coquitlam adanacs 20 3 34
2004 coquitlam adanacs 20 9 22
2005 coquitlam adanacs 18 4 27
2006 coquitlam adanacs 18 6 23
2007 coquitlam adanacs 18 7 20
2008 coquitlam adanacs 18 3 28
2009 coquitlam adanacs 18 9 18
total 45 seasons 1094 493 1177
Step 2: Extract the sum of 'points' column then add column 'total_points' to existing table.
season team_name games losses points
1965 coquitlam adanacs 30 18 24
1966 coquitlam adanacs 30 11 38
1967 coquitlam adanacs 30 15 29
1969 coquitlam adanacs 29 3 52
1970 coquitlam adanacs 30 16 28
1971 coquitlam adanacs 31 12 37
1972 coquitlam adanacs 36 23 18
1973 coquitlam adanacs 25 9 32
1974 coquitlam adanacs 24 15 17
1975 coquitlam adanacs 24 16 16
1976 coquitlam adanacs 24 15 18
1977 coquitlam adanacs 24 13 22
1978 coquitlam adanacs 24 13 21
1979 coquitlam adanacs 30 12 35
1980 coquitlam adanacs 24 9 30
1981 coquitlam adanacs 24 7 34
1982 coquitlam adanacs 24 16 16
1983 coquitlam adanacs 24 14 20
1984 coquitlam adanacs 24 14 20
1985 coquitlam adanacs 24 10 28
1986 coquitlam adanacs 24 14 20
1987 coquitlam adanacs 24 11 26
1988 coquitlam adanacs 24 11 26
1989 coquitlam adanacs 24 13 22
1990 coquitlam adanacs 24 18 12
1991 coquitlam adanacs 24 6 36
1992 coquitlam adanacs 24 14 20
1993 coquitlam adanacs 23 6 34
1994 coquitlam adanacs 20 7 26
1995 coquitlam adanacs 25 11 25
1996 coquitlam adanacs 20 15 10
1997 coquitlam adanacs 20 10 19
1998 coquitlam adanacs 25 9 31
1999 coquitlam adanacs 25 7 36
2000 coquitlam adanacs 25 11 28
2001 coquitlam adanacs 20 8 24
2002 coquitlam adanacs 20 6 27
2003 coquitlam adanacs 20 3 34
2004 coquitlam adanacs 20 9 22
2005 coquitlam adanacs 18 4 27
2006 coquitlam adanacs 18 6 23
2007 coquitlam adanacs 18 7 20
2008 coquitlam adanacs 18 3 28
2009 coquitlam adanacs 18 9 18
Step 3: Select rows where 'total_points' is 1177.
season team_name games losses points total_points
1965 coquitlam adanacs 30 18 24 1129
1966 coquitlam adanacs 30 11 38 1129
1967 coquitlam adanacs 30 15 29 1129
1969 coquitlam adanacs 29 3 52 1129
1970 coquitlam adanacs 30 16 28 1129
1971 coquitlam adanacs 31 12 37 1129
1972 coquitlam adanacs 36 23 18 1129
1973 coquitlam adanacs 25 9 32 1129
1974 coquitlam adanacs 24 15 17 1129
1975 coquitlam adanacs 24 16 16 1129
1976 coquitlam adanacs 24 15 18 1129
1977 coquitlam adanacs 24 13 22 1129
1978 coquitlam adanacs 24 13 21 1129
1979 coquitlam adanacs 30 12 35 1129
1980 coquitlam adanacs 24 9 30 1129
1981 coquitlam adanacs 24 7 34 1129
1982 coquitlam adanacs 24 16 16 1129
1983 coquitlam adanacs 24 14 20 1129
1984 coquitlam adanacs 24 14 20 1129
1985 coquitlam adanacs 24 10 28 1129
1986 coquitlam adanacs 24 14 20 1129
1987 coquitlam adanacs 24 11 26 1129
1988 coquitlam adanacs 24 11 26 1129
1989 coquitlam adanacs 24 13 22 1129
1990 coquitlam adanacs 24 18 12 1129
1991 coquitlam adanacs 24 6 36 1129
1992 coquitlam adanacs 24 14 20 1129
1993 coquitlam adanacs 23 6 34 1129
1994 coquitlam adanacs 20 7 26 1129
1995 coquitlam adanacs 25 11 25 1129
1996 coquitlam adanacs 20 15 10 1129
1997 coquitlam adanacs 20 10 19 1129
1998 coquitlam adanacs 25 9 31 1129
1999 coquitlam adanacs 25 7 36 1129
2000 coquitlam adanacs 25 11 28 1129
2001 coquitlam adanacs 20 8 24 1129
2002 coquitlam adanacs 20 6 27 1129
2003 coquitlam adanacs 20 3 34 1129
2004 coquitlam adanacs 20 9 22 1129
2005 coquitlam adanacs 18 4 27 1129
2006 coquitlam adanacs 18 6 23 1129
2007 coquitlam adanacs 18 7 20 1129
2008 coquitlam adanacs 18 3 28 1129
2009 coquitlam adanacs 18 9 18 1129
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
season team_name games losses points total_points
verification_result
FALSE