Year | State | Total Jobs |
1983 | TN | 2,421.25 |
1984 | TN | 2,516.75 |
1985 | TN | 2,595 |
1986 | TN | 2,321.50 |
1987 | TN | 1,976 |
1988 | TN | 1,990 |
1989 | TN | 1,976.50 |
1990 | TN | 1,725.50 |
1991 | TN | 1,256.75 |
1992 | TN | 848.75 |
1993 | TN | 679.25 |
1994 | TN | 685.25 |
1995 | TN | 646 |
1996 | TN | 708.75 |
1997 | TN | 644.50 |
1998 | TN | 493.25 |
1999 | TN | 549.25 |
2000 | TN | 436.25 |
2001 | TN | 499.25 |
2002 | TN | 555.75 |
2003 | TN | 503.75 |
2004 | TN | 553 |
2005 | TN | 628 |
2006 | TN | 616.75 |
2007 | TN | 544.75 |
2008 | TN | 557.75 |
2009 | TN | 652.50 |
2010 | TN | 550 |
SELECT YEAR AS Year , cr_State_Abbr AS State_name , if ( year=2024, sum(AVENEMP)/(select count(distinct Quarter) from osc_production where year=2024) , sum(AVENEMP)/4 ) AS "Total_Jobs" FROM osc_production WHERE YEAR BETWEEN "1983" AND "2010" AND cr_State_Abbr LIKE "TN" GROUP BY YEAR , cr_State_Abbr ORDER BY Year LIMIT 1000;