Changes
Jump to navigation
Jump to search
→Creating the tables
Up varchar
);
==Some statistics for the Patent table==
SELECT gyear, COUNT(*) FROM patents GROUP BY gyear ORDER BY gyear;
gyear | count
-------+--------
1975 | 72000
1976 | 70226
1977 | 65269
1978 | 66102
1979 | 48854
1980 | 61819
1981 | 65771
1982 | 57888
1983 | 56860
1984 | 67200
1985 | 71661
1986 | 70860
1987 | 82952
1988 | 77924
1989 | 95537
1990 | 90364
1991 | 96513
1992 | 97444
1993 | 98342
1994 | 101676
1995 | 101419
1996 | 109645
1997 | 111984
1998 | 147574
1999 | 153593
2000 | 157596
2001 | 166065
2002 | 167424
2003 | 169105
2004 | 164413
2005 | 143927
2006 | 173922
2007 | 157502
2008 | 157894
2009 | 167537
2010 | 219909
(36 rows)
