CREATE TABLE [dbo].[Presidents](
	[PresidentNumber] [int] IDENTITY(1,1) NOT NULL,
	[President] [varchar](255) NULL,
	[YearsInOffice] [int] NULL,
	[YearFirstInaugurated] [int] NULL,
	[AgeAtInauguration] [int] NULL,
	[StateElectedFrom] [varchar](255) NULL,
	[ElectoralVotes] [int] NULL,
	[popularVotes] [varchar](255) NULL,
	[NationalTotalVotes] [varchar](255) NULL,
	[TotalElectoralVotes] [int] NULL,
	[RatingPoints] [int] NULL,
	[PoliticalParty] [varchar](255) NULL,
	[Occupation] [varchar](255) NULL,
	[CollegeName] [varchar](255) NULL
) 

SET IDENTITY_INSERT [dbo].[Presidents] ON
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (1, CONVERT(TEXT, N'George Washington'), 8, 1789, 57, CONVERT(TEXT, N'Virginia'), 69, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), 69, 842, CONVERT(TEXT, N'None'), CONVERT(TEXT, N'Planter'), CONVERT(TEXT, N'None'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (2, CONVERT(TEXT, N'John Adams'), 4, 1797, 61, CONVERT(TEXT, N'Massachusetts'), 132, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), 139, 598, CONVERT(TEXT, N'Federalist'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Harvard'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (3, CONVERT(TEXT, N'Thomas Jefferson'), 8, 1801, 57, CONVERT(TEXT, N'Virginia'), 73, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), 137, 711, CONVERT(TEXT, N'Democratic-Republican'), CONVERT(TEXT, N'Planter, Lawyer'), CONVERT(TEXT, N'William and Mary'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (4, CONVERT(TEXT, N'James Madison'), 8, 1809, 57, CONVERT(TEXT, N'Virginia'), 122, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), 176, 567, CONVERT(TEXT, N'Democratic-Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Princeton'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (5, CONVERT(TEXT, N'James Monroe'), 8, 1817, 58, CONVERT(TEXT, N'Virginia'), 183, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), 221, 602, CONVERT(TEXT, N'Democratic-Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'William and Mary'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (6, CONVERT(TEXT, N'John Quincy Adams'), 4, 1825, 57, CONVERT(TEXT, N'Massachusetts'), 84, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), 261, 564, CONVERT(TEXT, N'Democratic-Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Harvard'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (7, CONVERT(TEXT, N'Andrew Jackson'), 8, 1829, 61, CONVERT(TEXT, N'Tennessee'), 178, NULL, NULL, 261, 632, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'None'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (8, CONVERT(TEXT, N'Martin Van Buren '), 4, 1837, 54, CONVERT(TEXT, N'New York'), 170, NULL, NULL, 294, 429, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'None'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (9, CONVERT(TEXT, N'William Henry Harrison'), 0, 1841, 68, CONVERT(TEXT, N'Ohio'), 234, NULL, NULL, 294, 329, CONVERT(TEXT, N'Whig'), CONVERT(TEXT, N'Soldier'), CONVERT(TEXT, N'Hampden-Sydney'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (10, CONVERT(TEXT, N'John Tyler'), 4, 1841, 51, CONVERT(TEXT, N'Virginia'), NULL, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), NULL, 369, CONVERT(TEXT, N'Whig'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'William and Mary'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (11, CONVERT(TEXT, N'James K. Polk'), 4, 1845, 49, CONVERT(TEXT, N'Tennessee'), 170, NULL, NULL, 275, 632, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'U. of North Carolina'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (12, CONVERT(TEXT, N'Zachary Taylor'), 1, 1849, 64, CONVERT(TEXT, N'Louisiana'), 163, NULL, NULL, 290, 447, CONVERT(TEXT, N'Whig'), CONVERT(TEXT, N'Soldier'), CONVERT(TEXT, N'None'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (13, CONVERT(TEXT, N'Millard Fillmore'), 3, 1850, 50, CONVERT(TEXT, N'New York'), NULL, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), NULL, 395, CONVERT(TEXT, N'Whig'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'None'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (14, CONVERT(TEXT, N'Franklin Pierce'), 4, 1853, 48, CONVERT(TEXT, N'New Hampshire'), 254, NULL, NULL, 296, 286, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Bowdoin'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (15, CONVERT(TEXT, N'James Buchanan'), 4, 1857, 65, CONVERT(TEXT, N'Pennsylvania'), 174, NULL, NULL, 296, 259, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Dickinson'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (16, CONVERT(TEXT, N'Abraham Lincoln'), 4, 1861, 52, CONVERT(TEXT, N'Illinois'), 180, NULL, NULL, 303, 900, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'None'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (17, CONVERT(TEXT, N'Andrew Johnson'), 4, 1865, 56, CONVERT(TEXT, N'Tennessee'), NULL, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), NULL, 280, CONVERT(TEXT, N'National Union'), CONVERT(TEXT, N'Tailor'), CONVERT(TEXT, N'None'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (18, CONVERT(TEXT, N'Ulysses S. Grant'), 8, 1869, 46, CONVERT(TEXT, N'Illinois'), 214, NULL, NULL, 294, 403, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Soldier'), CONVERT(TEXT, N'US Military Academy'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (19, CONVERT(TEXT, N'Rutherford B. Hayes'), 4, 1877, 54, CONVERT(TEXT, N'Ohio'), 185, NULL, NULL, 369, 477, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Kenyon'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (20, CONVERT(TEXT, N'James A. Garfield'), 0, 1881, 49, CONVERT(TEXT, N'Ohio'), 214, NULL, NULL, 369, 444, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Williams'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (21, CONVERT(TEXT, N'Chester A. Arthur'), 3, 1881, 50, CONVERT(TEXT, N'New York'), NULL, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), NULL, 423, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Union'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (22, CONVERT(TEXT, N'Grover Cleveland'), 4, 1885, 47, CONVERT(TEXT, N'New York'), 219, NULL, NULL, 401, 576, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'None'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (23, CONVERT(TEXT, N'Benjamin Harrison'), 4, 1889, 55, CONVERT(TEXT, N'Indiana'), 233, NULL, NULL, 401, 426, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Miami'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (24, CONVERT(TEXT, N'Grover Cleveland'), 4, 1893, 55, CONVERT(TEXT, N'New York'), 277, NULL, NULL, 444, 576, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'None'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (25, CONVERT(TEXT, N'William McKinley'), 4, 1897, 54, CONVERT(TEXT, N'Ohio'), 271, NULL, NULL, 447, 601, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Allegheny College'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (26, CONVERT(TEXT, N'Theodore Roosevelt'), 8, 1901, 42, CONVERT(TEXT, N'New York'), NULL, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), NULL, 810, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Author'), CONVERT(TEXT, N'Harvard'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (27, CONVERT(TEXT, N'William Howard Taft'), 4, 1909, 51, CONVERT(TEXT, N'Ohio'), 321, NULL, NULL, 483, 491, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Yale'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (28, CONVERT(TEXT, N'Woodrow Wilson'), 8, 1913, 56, CONVERT(TEXT, N'New Jersey'), 435, NULL, NULL, 531, 723, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Educator'), CONVERT(TEXT, N'Princeton'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (29, CONVERT(TEXT, N'Warren G. Harding'), 2, 1921, 55, CONVERT(TEXT, N'Ohio'), 404, NULL, NULL, 531, 326, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Editor'), CONVERT(TEXT, N'None'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (30, CONVERT(TEXT, N'Calvin Coolidge'), 6, 1923, 51, CONVERT(TEXT, N'Massachusetts'), NULL, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), NULL, 451, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Amherst'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (31, CONVERT(TEXT, N'Herbert Hoover'), 4, 1929, 54, CONVERT(TEXT, N'California'), 444, NULL, NULL, 531, 400, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Engineer'), CONVERT(TEXT, N'Stanford'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (32, CONVERT(TEXT, N'Franklin Roosevelt'), 12, 1933, 51, CONVERT(TEXT, N'New York'), 472, NULL, NULL, 531, 876, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Harvard'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (33, CONVERT(TEXT, N'Harry S. Truman'), 8, 1945, 60, CONVERT(TEXT, N'Missouri'), NULL, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), NULL, 753, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Businessman'), CONVERT(TEXT, N'None'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (34, CONVERT(TEXT, N'Dwight D. Eisenhower'), 8, 1953, 62, CONVERT(TEXT, N'New York'), 442, NULL, NULL, 531, 699, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Soldier'), CONVERT(TEXT, N'US Military Academy'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (35, CONVERT(TEXT, N'John F. Kennedy'), 3, 1961, 43, CONVERT(TEXT, N'Massachusetts'), 303, NULL, NULL, 537, 704, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Author'), CONVERT(TEXT, N'Harvard'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (36, CONVERT(TEXT, N'Lyndon B. Johnson'), 5, 1963, 55, CONVERT(TEXT, N'Texas'), NULL, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), NULL, 655, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Teacher'), CONVERT(TEXT, N'Southwest Texas State'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (37, CONVERT(TEXT, N'Richard M. Nixon'), 5, 1969, 56, CONVERT(TEXT, N'New York'), 301, NULL, NULL, 538, 477, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Whittier'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (38, CONVERT(TEXT, N'Gerald Ford'), 3, 1974, 61, CONVERT(TEXT, N'Michigan'), NULL, CONVERT(TEXT, N'NA()'), CONVERT(TEXT, N'NA()'), NULL, 495, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Michigan'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (39, CONVERT(TEXT, N'Jimmy Carter'), 4, 1977, 52, CONVERT(TEXT, N'Georgia'), 297, NULL, NULL, 538, 518, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Businessman'), CONVERT(TEXT, N'US Naval Academy'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (40, CONVERT(TEXT, N'Ronald Reagan'), 8, 1981, 69, CONVERT(TEXT, N'California'), 489, NULL, NULL, 538, 634, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Actor'), CONVERT(TEXT, N'Eureka College'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (41, CONVERT(TEXT, N'George Bush'), 4, 1989, 64, CONVERT(TEXT, N'Texas'), 426, NULL, NULL, 538, 548, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Businessman'), CONVERT(TEXT, N'Yale'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (42, CONVERT(TEXT, N'Bill Clinton'), 8, 1993, 46, CONVERT(TEXT, N'Arkansas'), 370, NULL, NULL, 538, 539, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Georgetown'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (43, CONVERT(TEXT, N'George W. Bush'), 8, 2001, 54, CONVERT(TEXT, N'Texas'), 271, NULL, NULL, 538, NULL, CONVERT(TEXT, N'Republican'), CONVERT(TEXT, N'Businessman'), CONVERT(TEXT, N'Yale'))
INSERT [dbo].[Presidents] ([PresidentNumber], [President], [YearsInOffice], [YearFirstInaugurated], [AgeAtInauguration], [StateElectedFrom], [ElectoralVotes], [popularVotes], [NationalTotalVotes], [TotalElectoralVotes], [RatingPoints], [PoliticalParty], [Occupation], [CollegeName]) VALUES (44, CONVERT(TEXT, N'Barack Obama'), 0, 2009, 47, CONVERT(TEXT, N'Illinois'), 365, NULL, NULL, 538, NULL, CONVERT(TEXT, N'Democrat'), CONVERT(TEXT, N'Lawyer'), CONVERT(TEXT, N'Columbia University'))
SET IDENTITY_INSERT [dbo].[Presidents] OFF