#10171
Find the genre of the person with the most number of oscar winnings.
If there are more than one person with the same number of oscar wins, return the first one in alphabetic order based on their name. Use the names as keys when joining the tables.
table name: oscar_nominee
table name: nominee_information
Solution:
select top_genre from nominee_information where name=(
select top 1 n.nominee from oscar_nominees as n
join nominee_information as i on n.nominee = i.name
where n.winner = 1
group by n.nominee
order by count(n.nominee) desc, nominee )
Output:
SQL Script:
USE [StrataScratch]
GO
/****** Object: Table [dbo].[nominee_information] Script Date: 14-01-2024 20:03:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[nominee_information](
[name] [varchar](50) NULL,
[amg_person_id] [varchar](50) NULL,
[top_genre] [varchar](50) NULL,
[birthday] [datetime] NULL,
[id] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[oscar_nominees] Script Date: 14-01-2024 20:03:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[oscar_nominees](
[year] [int] NULL,
[category] [varchar](50) NULL,
[nominee] [varchar](50) NULL,
[movie] [varchar](550) NULL,
[winner] [bit] NULL,
[id] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Ruby Dee', N'P 18243', N'Drama', CAST(N'1924-10-27T00:00:00.000' AS DateTime), 234)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Hal Holbrook', N'P 32790', N'Drama', CAST(N'1925-02-17T00:00:00.000' AS DateTime), 241)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Cloris Leachman', N'P 41211', N'Comedy', CAST(N'1926-04-30T00:00:00.000' AS DateTime), 257)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Rosemary Harris', N'P 30676', N'Drama', CAST(N'1930-09-19T00:00:00.000' AS DateTime), 301)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Martin Landau', N'P 40247', N'Spy Film', CAST(N'1931-06-20T00:00:00.000' AS DateTime), 312)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Ian Holm', N'P 32962', N'Drama', CAST(N'1931-09-12T00:00:00.000' AS DateTime), 315)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Debbie Reynolds', N'P 59782', N'Comedy', CAST(N'1932-04-01T00:00:00.000' AS DateTime), 321)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Michael Caine', N'P 10198', N'Thriller', CAST(N'1933-03-14T00:00:00.000' AS DateTime), 335)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Alan Alda', N'P 79264', N'Comedy', CAST(N'1936-01-28T00:00:00.000' AS DateTime), 366)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Albert Finney', N'P 23545', N'Drama', CAST(N'1936-05-09T00:00:00.000' AS DateTime), 371)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Morgan Freeman', N'P 90514', N'Drama', CAST(N'1937-06-01T00:00:00.000' AS DateTime), 386)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Anthony Hopkins', N'P 94812', N'Drama', CAST(N'1937-12-31T00:00:00.000' AS DateTime), 391)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Ian McKellen', N'P 47684', N'Drama', CAST(N'1939-05-25T00:00:00.000' AS DateTime), 409)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Tom Conti', N'P 14627', N'Drama', CAST(N'1941-11-22T00:00:00.000' AS DateTime), 437)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Bob Hoskins', N'P 33185', N'Drama', CAST(N'1942-10-26T00:00:00.000' AS DateTime), 447)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Joe Pesci', N'P 56237', N'Comedy', CAST(N'1943-02-09T00:00:00.000' AS DateTime), 448)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Robert De Niro', N'P 17593', N'Drama', CAST(N'1943-08-17T00:00:00.000' AS DateTime), 452)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Sam Shepard', N'P111142', N'Drama', CAST(N'1943-11-05T00:00:00.000' AS DateTime), 456)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Ben Kingsley', N'P 38383', N'Drama', CAST(N'1943-12-31T00:00:00.000' AS DateTime), 458)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Gary Busey', N'P 9844', N'Drama', CAST(N'1944-06-29T00:00:00.000' AS DateTime), 463)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Michael Douglas', N'P 88134', N'Drama', CAST(N'1944-09-25T00:00:00.000' AS DateTime), 464)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Sally Kirkland', N'P 38510', N'Drama', CAST(N'1944-10-31T00:00:00.000' AS DateTime), 465)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Helen Mirren', N'P 49576', N'Drama', CAST(N'1945-07-26T00:00:00.000' AS DateTime), 471)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Diane Keaton', N'P 96996', N'Comedy', CAST(N'1946-01-05T00:00:00.000' AS DateTime), 476)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Bruce Davison', N'P 17454', N'Drama', CAST(N'1946-06-28T00:00:00.000' AS DateTime), 482)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Tommy Lee Jones', N'P 36238', N'Drama', CAST(N'1946-09-15T00:00:00.000' AS DateTime), 485)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Stephen Rea', N'P 59079', N'Drama', CAST(N'1946-10-31T00:00:00.000' AS DateTime), 488)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Sally Field', N'P 89714', N'Comedy', CAST(N'1946-11-06T00:00:00.000' AS DateTime), 489)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Richard Jenkins', N'P 35464', N'Drama', CAST(N'1947-05-04T00:00:00.000' AS DateTime), 494)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Kevin Kline', N'P 38699', N'Comedy', CAST(N'1947-10-24T00:00:00.000' AS DateTime), 500)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Dianne Wiest', N'P 76163', N'Drama', CAST(N'1948-03-28T00:00:00.000' AS DateTime), 506)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Kathy Bates', N'P 4516', N'Drama', CAST(N'1948-06-28T00:00:00.000' AS DateTime), 508)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Samuel L. Jackson', N'P 34866', N'Drama', CAST(N'1948-12-21T00:00:00.000' AS DateTime), 511)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Gerard Depardieu', N'P 87517', N'Drama', CAST(N'1948-12-27T00:00:00.000' AS DateTime), 512)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'David Strathairn', N'P 68638', N'Drama', CAST(N'1949-01-26T00:00:00.000' AS DateTime), 513)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Jessica Lange', N'P 40447', N'Drama', CAST(N'1949-04-20T00:00:00.000' AS DateTime), 514)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Jim Broadbent', N'P 8575', N'Drama', CAST(N'1949-05-24T00:00:00.000' AS DateTime), 515)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Sigourney Weaver', N'P 75144', N'Comedy', CAST(N'1949-10-08T00:00:00.000' AS DateTime), 518)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Jeff Bridges', N'P 3197', N'Drama', CAST(N'1949-12-04T00:00:00.000' AS DateTime), 519)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Julie Walters', N'P 74515', N'Drama', CAST(N'1950-02-22T00:00:00.000' AS DateTime), 521)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Ed Harris', N'P 30614', N'Drama', CAST(N'1950-11-28T00:00:00.000' AS DateTime), 531)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Chazz Palminteri', N'P 54860', N'Drama', CAST(N'1952-05-15T00:00:00.000' AS DateTime), 540)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Liam Neeson', N'P 52070', N'Drama', CAST(N'1952-06-07T00:00:00.000' AS DateTime), 541)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Dan Aykroyd', N'P 80282', N'Comedy', CAST(N'1952-07-01T00:00:00.000' AS DateTime), 544)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Denzel Washington', N'P 74843', N'Drama', CAST(N'1954-12-28T00:00:00.000' AS DateTime), 562)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Kevin Costner', N'P 15189', N'History [nf]', CAST(N'1955-01-18T00:00:00.000' AS DateTime), 563)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Willem Dafoe', N'P 16547', N'Drama', CAST(N'1955-07-22T00:00:00.000' AS DateTime), 570)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Whoopi Goldberg', N'P 27431', N'Comedy', CAST(N'1955-11-13T00:00:00.000' AS DateTime), 573)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Joan Allen', N'P 1026', N'Drama', CAST(N'1956-08-20T00:00:00.000' AS DateTime), 580)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Christoph Waltz', N'P221135', N'Drama', CAST(N'1956-10-04T00:00:00.000' AS DateTime), 581)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Daniel Day Lewis', N'P 17559', N'Drama', CAST(N'1957-04-29T00:00:00.000' AS DateTime), 582)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Daniel Day-Lewis', N'P 17559', N'Drama', CAST(N'1957-04-29T00:00:00.000' AS DateTime), 583)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Frances McDormand', N'P 47305', N'Drama', CAST(N'1957-06-23T00:00:00.000' AS DateTime), 584)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Sharon Stone', N'P 68496', N'Drama', CAST(N'1958-03-10T00:00:00.000' AS DateTime), 588)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Gary Oldman', N'P 53946', N'Drama', CAST(N'1958-03-21T00:00:00.000' AS DateTime), 590)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Alec Baldwin', N'P 3515', N'Comedy', CAST(N'1958-04-03T00:00:00.000' AS DateTime), 591)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Michelle Pfeiffer', N'P 56469', N'Drama', CAST(N'1958-04-29T00:00:00.000' AS DateTime), 592)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Angela Bassett', N'P 4466', N'Drama', CAST(N'1958-08-16T00:00:00.000' AS DateTime), 594)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Viggo Mortensen', N'P 50903', N'Drama', CAST(N'1958-10-20T00:00:00.000' AS DateTime), 597)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Catherine Keener', N'P 37341', N'Comedy', CAST(N'1959-03-26T00:00:00.000' AS DateTime), 600)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Emma Thompson', N'P 70692', N'Drama', CAST(N'1959-04-15T00:00:00.000' AS DateTime), 601)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'John Hawkes', N'P 31099', N'Comedy', CAST(N'1959-09-11T00:00:00.000' AS DateTime), 605)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Ken Watanabe', N'P 74900', N'Drama', CAST(N'1959-10-21T00:00:00.000' AS DateTime), 606)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Stanley Tucci', N'P 72023', N'Comedy', CAST(N'1960-01-11T00:00:00.000' AS DateTime), 608)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Thomas Haden Church', N'P195520', N'Comedy', CAST(N'1960-06-17T00:00:00.000' AS DateTime), 611)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Colin Firth', N'P 23590', N'Drama', CAST(N'1960-09-10T00:00:00.000' AS DateTime), 614)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Melissa Leo', N'P 41835', N'Drama', CAST(N'1960-09-14T00:00:00.000' AS DateTime), 615)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Eddie Murphy', N'P 51440', N'Comedy', CAST(N'1961-04-03T00:00:00.000' AS DateTime), 620)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'George Clooney', N'P 13722', N'Comedy', CAST(N'1961-05-06T00:00:00.000' AS DateTime), 622)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Jackie Earle Haley', N'P 29701', N'Comedy', CAST(N'1961-07-14T00:00:00.000' AS DateTime), 625)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Woody Harrelson', N'P 30548', N'Comedy', CAST(N'1961-07-23T00:00:00.000' AS DateTime), 628)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Laurence Fishburne', N'P 23625', N'Drama', CAST(N'1961-07-30T00:00:00.000' AS DateTime), 629)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Tom Cruise', N'P 86295', N'Drama', CAST(N'1962-07-03T00:00:00.000' AS DateTime), 631)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Jodie Foster', N'P 90220', N'Drama', CAST(N'1962-11-19T00:00:00.000' AS DateTime), 633)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Ralph Fiennes', N'P 23390', N'Drama', CAST(N'1962-12-22T00:00:00.000' AS DateTime), 635)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Johnny Depp', N'P 18682', N'Drama', CAST(N'1963-06-09T00:00:00.000' AS DateTime), 636)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Brad Pitt', N'P 56988', N'Drama', CAST(N'1963-12-18T00:00:00.000' AS DateTime), 643)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Nicolas Cage', N'P 10155', N'Drama', CAST(N'1964-01-07T00:00:00.000' AS DateTime), 644)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Matt Dillon', N'P 19210', N'Drama', CAST(N'1964-02-18T00:00:00.000' AS DateTime), 646)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Juliette Binoche', N'P 6261', N'Drama', CAST(N'1964-03-09T00:00:00.000' AS DateTime), 647)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Russell Crowe', N'P 15959', N'Drama', CAST(N'1964-04-07T00:00:00.000' AS DateTime), 648)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Djimon Hounsou', N'P 33391', N'Drama', CAST(N'1964-04-24T00:00:00.000' AS DateTime), 649)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Sandra Bullock', N'P 9472', N'Comedy', CAST(N'1964-07-26T00:00:00.000' AS DateTime), 650)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Rosie Perez', N'P106101', N'Drama', CAST(N'1964-09-06T00:00:00.000' AS DateTime), 651)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Don Cheadle', N'P 12587', N'Drama', CAST(N'1964-11-29T00:00:00.000' AS DateTime), 653)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Diane Lane', N'P 40350', N'Drama', CAST(N'1965-01-22T00:00:00.000' AS DateTime), 655)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Robert Downey Jr.', N'P 19966', N'Comedy', CAST(N'1965-04-04T00:00:00.000' AS DateTime), 656)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Helena Bonham Carter', N'P 7266', N'Drama', CAST(N'1966-05-26T00:00:00.000' AS DateTime), 660)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Paul Giamatti', N'P 26680', N'Comedy', CAST(N'1967-06-06T00:00:00.000' AS DateTime), 667)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Nicole Kidman', N'P 38065', N'Drama', CAST(N'1967-06-20T00:00:00.000' AS DateTime), 668)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Mark Ruffalo', N'P197651', N'Drama', CAST(N'1967-11-22T00:00:00.000' AS DateTime), 673)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Jamie Foxx', N'P 24604', N'Comedy', CAST(N'1967-12-13T00:00:00.000' AS DateTime), 675)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Cuba Gooding, Jr.', N'P 27665', N'Drama', CAST(N'1968-01-02T00:00:00.000' AS DateTime), 677)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Josh Brolin', N'P 8657', N'Drama', CAST(N'1968-02-12T00:00:00.000' AS DateTime), 678)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Will Smith', N'P 66596', N'Comedy', CAST(N'1968-09-25T00:00:00.000' AS DateTime), 681)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Hugh Jackman', N'P269258', N'Action', CAST(N'1968-10-12T00:00:00.000' AS DateTime), 683)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Javier Bardem', N'P 3887', N'Drama', CAST(N'1969-03-01T00:00:00.000' AS DateTime), 684)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Terrence Howard', N'P 33528', N'Drama', CAST(N'1969-03-11T00:00:00.000' AS DateTime), 685)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Cate Blanchett', N'P215038', N'Drama', CAST(N'1969-05-14T00:00:00.000' AS DateTime), 687)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Edward Norton', N'P215904', N'Drama', CAST(N'1969-08-18T00:00:00.000' AS DateTime), 688)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Catherine Zeta-Jones', N'P 36062', N'Comedy', CAST(N'1969-09-25T00:00:00.000' AS DateTime), 689)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Queen Latifah', N'P 40714', N'Comedy', CAST(N'1970-03-18T00:00:00.000' AS DateTime), 692)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Matt Damon', N'P 16762', N'Drama', CAST(N'1970-10-08T00:00:00.000' AS DateTime), 698)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Jeremy Renner', N'P199226', N'Drama', CAST(N'1971-01-07T00:00:00.000' AS DateTime), 701)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Rachel Weisz', N'P216376', N'Drama', CAST(N'1971-03-07T00:00:00.000' AS DateTime), 702)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Winona Ryder', N'P 62446', N'Drama', CAST(N'1971-10-29T00:00:00.000' AS DateTime), 705)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Gwyneth Paltrow', N'P 54871', N'Drama', CAST(N'1972-09-28T00:00:00.000' AS DateTime), 707)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Toni Collette', N'P 14165', N'Drama', CAST(N'1972-11-01T00:00:00.000' AS DateTime), 708)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Vera Farmiga', N'P241678', N'Drama', CAST(N'1973-08-06T00:00:00.000' AS DateTime), 712)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Christian Bale', N'P 3538', N'Drama', CAST(N'1974-01-30T00:00:00.000' AS DateTime), 713)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Michael Shannon', N'P516240', N'Drama', CAST(N'1974-08-07T00:00:00.000' AS DateTime), 716)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Charlize Theron', N'P216257', N'Drama', CAST(N'1975-08-07T00:00:00.000' AS DateTime), 722)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Amy Adams', N'P273224', N'Comedy', CAST(N'1975-08-20T00:00:00.000' AS DateTime), 724)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Marion Cotillard', N'P195575', N'Drama', CAST(N'1975-09-30T00:00:00.000' AS DateTime), 726)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Reese Witherspoon', N'P 77086', N'Comedy', CAST(N'1976-03-22T00:00:00.000' AS DateTime), 728)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Jessica Chastain', N'P470479', N'Adventure', CAST(N'1977-03-29T00:00:00.000' AS DateTime), 730)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Samantha Morton', N'P230665', N'Drama', CAST(N'1977-05-13T00:00:00.000' AS DateTime), 731)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'James Franco', N'P299361', N'Drama', CAST(N'1978-04-19T00:00:00.000' AS DateTime), 733)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Kate Hudson', N'P263367', N'Comedy', CAST(N'1979-04-19T00:00:00.000' AS DateTime), 735)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Michelle Williams', N'P198320', N'Drama', CAST(N'1980-09-09T00:00:00.000' AS DateTime), 736)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Ryan Gosling', N'P279096', N'Drama', CAST(N'1980-11-12T00:00:00.000' AS DateTime), 737)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Rinko Kikuchi', N'P475244', N'Drama', CAST(N'1981-01-06T00:00:00.000' AS DateTime), 739)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Jennifer Hudson', N'P454405', N'Drama', CAST(N'1981-09-12T00:00:00.000' AS DateTime), 742)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Anne Hathaway', N'P292630', N'Drama', CAST(N'1982-11-12T00:00:00.000' AS DateTime), 744)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Jonah Hill', N'P418718', N'Comedy', CAST(N'1983-12-20T00:00:00.000' AS DateTime), 747)
GO
INSERT [dbo].[nominee_information] ([name], [amg_person_id], [top_genre], [birthday], [id]) VALUES (N'Jennifer Lawrence', N'P562566', N'Drama', CAST(N'1990-08-15T00:00:00.000' AS DateTime), 755)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actor in a leading role', N'James Franco', N'127 Hours', 0, 648)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actor in a supporting role', N'Benicio Del Toro', N'21 Grams', 0, 139)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actress in a leading role', N'Naomi Watts', N'21 Grams', 0, 1119)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actress in a supporting role', N'Jennifer Connelly', N'A Beautiful Mind', 1, 710)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actor in a leading role', N'Russell Crowe', N'A Beautiful Mind', 0, 1315)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actor in a leading role', N'Demi?n Bichir', N'A Better Life', 0, 306)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actor in a supporting role', N'William Hurt', N'A History of Violence', 0, 1532)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actor in a leading role', N'Colin Firth', N'A Single Man', 0, 272)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actor in a leading role', N'Jack Nicholson', N'About Schmidt', 0, 624)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actress in a supporting role', N'Kathy Bates', N'About Schmidt', 0, 871)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actor in a supporting role', N'Chris Cooper', N'Adaptation', 1, 243)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actress in a supporting role', N'Meryl Streep', N'Adaptation', 0, 1062)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actor in a leading role', N'Nicolas Cage', N'Adaptation', 0, 1132)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actress in a leading role', N'Glenn Close', N'Albert Nobbs', 0, 511)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actress in a supporting role', N'Janet McTeer', N'Albert Nobbs', 0, 686)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actor in a supporting role', N'Jon Voight', N'Ali', 0, 798)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actor in a leading role', N'Will Smith', N'Ali', 0, 1517)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actress in a supporting role', N'Frances McDormand', N'Almost Famous', 0, 429)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actress in a supporting role', N'Kate Hudson', N'Almost Famous', 0, 848)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actress in a supporting role', N'Ruby Dee', N'American Gangster', 0, 1310)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actress in a leading role', N'Emmanuelle Riva', N'Amour', 0, 401)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actress in a leading role', N'Carey Mulligan', N'An Education', 0, 192)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actress in a supporting role', N'Jacki Weaver', N'Animal Kingdom', 0, 632)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actor in a supporting role', N'Alan Arkin', N'Argo', 0, 23)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actress in a supporting role', N'Saoirse Ronan', N'Atonement', 0, 1338)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actress in a leading role', N'Julie Christie', N'Away from Her', 0, 837)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actress in a supporting role', N'Adriana Barraza', N'Babel', 0, 3)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actress in a supporting role', N'Rinko Kikuchi', N'Babel', 0, 1253)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actress in a leading role', N'Quvenzhan_ Wallis', N'Beasts of the Southern Wild', 0, 1216)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actor in a leading role', N'Javier Bardem', N'Before Night Falls', 0, 692)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actor in a supporting role', N'Christopher Plummer', N'Beginners', 1, 250)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actress in a leading role', N'Annette Bening', N'Being Julia', 0, 86)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actress in a supporting role', N'Julie Walters', N'Billy Elliot', 0, 840)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actor in a leading role', N'Javier Bardem', N'Biutiful', 0, 694)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actress in a leading role', N'Natalie Portman', N'Black Swan', 1, 1122)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actor in a supporting role', N'Djimon Hounsou', N'Blood Diamond', 0, 333)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actor in a leading role', N'Leonardo DiCaprio', N'Blood Diamond', 0, 927)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actress in a leading role', N'Michelle Williams', N'Blue Valentine', 0, 1087)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actress in a supporting role', N'Melissa McCarthy', N'Bridesmaids', 0, 1043)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actress in a leading role', N'Ren_e Zellweger', N'Bridget Jones''s Diary', 0, 1230)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actor in a leading role', N'Heath Ledger', N'Brokeback Mountain', 0, 550)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actor in a supporting role', N'Jake Gyllenhaal', N'Brokeback Mountain', 0, 636)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actress in a supporting role', N'Michelle Williams', N'Brokeback Mountain', 0, 1086)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actress in a supporting role', N'Catherine Keener', N'Capote', 0, 211)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actor in a leading role', N'Philip Seymour Hoffman', N'Capote', 1, 1207)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actor in a leading role', N'Tom Hanks', N'Cast Away', 0, 1457)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actor in a supporting role', N'Christopher Walken', N'Catch Me If You Can', 0, 252)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actress in a leading role', N'Angelina Jolie', N'Changeling', 0, 57)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actor in a supporting role', N'Philip Seymour Hoffman', N'Charlie Wilson''s War', 0, 1208)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actress in a supporting role', N'Catherine Zeta-Jones', N'Chicago', 1, 212)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actor in a supporting role', N'John C. Reilly', N'Chicago', 0, 769)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actress in a supporting role', N'Queen Latifah', N'Chicago', 0, 1214)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actress in a leading role', N'Ren_e Zellweger', N'Chicago', 0, 1231)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actress in a supporting role', N'Judi Dench', N'Chocolat', 0, 814)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actress in a leading role', N'Juliette Binoche', N'Chocolat', 0, 842)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actor in a supporting role', N'Paul Giamatti', N'Cinderella Man', 0, 1160)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actor in a supporting role', N'Clive Owen', N'Closer', 0, 269)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actress in a supporting role', N'Natalie Portman', N'Closer', 0, 1121)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actor in a leading role', N'Jude Law', N'Cold Mountain', 0, 811)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actress in a supporting role', N'Ren_e Zellweger', N'Cold Mountain', 1, 1232)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actor in a supporting role', N'Jamie Foxx', N'Collateral', 0, 665)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actor in a supporting role', N'Matt Dillon', N'Crash', 0, 1026)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actor in a leading role', N'Jeff Bridges', N'Crazy Heart', 1, 707)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actress in a supporting role', N'Maggie Gyllenhaal', N'Crazy Heart', 0, 961)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actor in a supporting role', N'Christoph Waltz', N'Django Unchained', 1, 248)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actress in a supporting role', N'Amy Adams', N'Doubt', 0, 44)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actress in a leading role', N'Meryl Streep', N'Doubt', 0, 1064)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actor in a supporting role', N'Philip Seymour Hoffman', N'Doubt', 0, 1209)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actress in a supporting role', N'Viola Davis', N'Doubt', 0, 1488)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actor in a supporting role', N'Eddie Murphy', N'Dreamgirls', 0, 361)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actress in a supporting role', N'Jennifer Hudson', N'Dreamgirls', 1, 711)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actor in a leading role', N'Viggo Mortensen', N'Eastern Promises', 0, 1485)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actress in a leading role', N'Cate Blanchett', N'Elizabeth: The Golden Age', 0, 206)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actor in a supporting role', N'Albert Finney', N'Erin Brockovich', 0, 31)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actress in a leading role', N'Julia Roberts', N'Erin Brockovich', 1, 826)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actress in a leading role', N'Kate Winslet', N'Eternal Sunshine of the Spotless Mind', 0, 853)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actor in a supporting role', N'Max von Sydow', N'Extremely Loud & Incredibly Close', 0, 1032)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actress in a leading role', N'Julianne Moore', N'Far from Heaven', 0, 829)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actor in a leading role', N'Johnny Depp', N'Finding Neverland', 0, 793)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actor in a leading role', N'Denzel Washington', N'Flight', 0, 314)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actress in a leading role', N'Salma Hayek', N'Frida', 0, 1328)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actor in a leading role', N'Frank Langella', N'Frost/Nixon', 0, 432)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actress in a leading role', N'Melissa Leo', N'Frozen River', 0, 1041)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actor in a leading role', N'Daniel Day-Lewis', N'Gangs of New York', 0, 286)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actor in a supporting role', N'Joaquin Phoenix', N'Gladiator', 0, 757)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actor in a leading role', N'Russell Crowe', N'Gladiator', 1, 1314)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actress in a supporting role', N'Amy Ryan', N'Gone Baby Gone', 0, 49)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actor in a leading role', N'David Strathairn', N'Good Night, and Good Luck.', 0, 293)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actress in a supporting role', N'Helen Mirren', N'Gosford Park', 0, 556)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actress in a supporting role', N'Maggie Smith', N'Gosford Park', 0, 968)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actor in a leading role', N'Ryan Gosling', N'Half Nelson', 0, 1319)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actor in a leading role', N'Don Cheadle', N'Hotel Rwanda', 0, 335)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actress in a supporting role', N'Sophie Okonedo', N'Hotel Rwanda', 0, 1381)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actor in a leading role', N'Ben Kingsley', N'House of Sand and Fog', 0, 137)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actress in a supporting role', N'Shohreh Aghdashloo', N'House of Sand and Fog', 0, 1363)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actor in a leading role', N'Terrence Howard', N'Hustle & Flow', 0, 1428)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actor in a leading role', N'Sean Penn', N'I Am Sam', 0, 1344)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actress in a supporting role', N'Cate Blanchett', N'I''m Not There', 0, 207)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actor in a supporting role', N'Djimon Hounsou', N'In America', 0, 332)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actress in a leading role', N'Samantha Morton', N'In America', 0, 1334)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actress in a supporting role', N'Marisa Tomei', N'In the Bedroom', 0, 989)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actress in a leading role', N'Sissy Spacek', N'In the Bedroom', 0, 1377)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actor in a leading role', N'Tom Wilkinson', N'In the Bedroom', 0, 1460)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actor in a leading role', N'Tommy Lee Jones', N'In the Valley of Elah', 0, 1464)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actor in a supporting role', N'Christoph Waltz', N'Inglourious Basterds', 1, 247)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actor in a supporting role', N'Hal Holbrook', N'Into the Wild', 0, 542)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actor in a supporting role', N'Matt Damon', N'Invictus', 0, 1025)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actor in a leading role', N'Morgan Freeman', N'Invictus', 0, 1116)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actor in a supporting role', N'Jim Broadbent', N'Iris', 1, 736)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actress in a leading role', N'Judi Dench', N'Iris', 0, 815)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actress in a supporting role', N'Kate Winslet', N'Iris', 0, 852)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actress in a leading role', N'Meryl Streep', N'Julie & Julia', 0, 1065)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actress in a supporting role', N'Amy Adams', N'Junebug', 0, 43)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actress in a leading role', N'Ellen Page', N'Juno', 0, 391)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actress in a supporting role', N'Laura Linney', N'Kinsey', 0, 898)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actress in a leading role', N'Marion Cotillard', N'La Vie en Rose', 1, 986)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actress in a supporting role', N'Anne Hathaway', N'Les Mis_rables', 1, 78)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actor in a leading role', N'Hugh Jackman', N'Les Mis_rables', 0, 576)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actor in a leading role', N'Daniel Day-Lewis', N'Lincoln', 1, 288)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actress in a supporting role', N'Sally Field', N'Lincoln', 0, 1325)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actor in a supporting role', N'Tommy Lee Jones', N'Lincoln', 0, 1465)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actor in a supporting role', N'Jackie Earle Haley', N'Little Children', 0, 634)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actress in a leading role', N'Kate Winslet', N'Little Children', 0, 854)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actress in a supporting role', N'Abigail Breslin', N'Little Miss Sunshine', 0, 1)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actor in a supporting role', N'Alan Arkin', N'Little Miss Sunshine', 1, 22)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actor in a leading role', N'Bill Murray', N'Lost in Translation', 0, 155)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actress in a leading role', N'Catalina Sandino Moreno', N'Maria Full of Grace', 0, 202)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actor in a leading role', N'George Clooney', N'Michael Clayton', 0, 477)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actress in a supporting role', N'Tilda Swinton', N'Michael Clayton', 1, 1442)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actor in a supporting role', N'Tom Wilkinson', N'Michael Clayton', 0, 1461)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actor in a supporting role', N'Josh Brolin', N'Milk', 0, 805)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actor in a leading role', N'Sean Penn', N'Milk', 1, 1346)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actor in a leading role', N'Clint Eastwood', N'Million Dollar Baby', 0, 268)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actress in a leading role', N'Hilary Swank', N'Million Dollar Baby', 1, 566)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actor in a supporting role', N'Morgan Freeman', N'Million Dollar Baby', 1, 1115)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actor in a leading role', N'Brad Pitt', N'Moneyball', 0, 168)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actor in a supporting role', N'Jonah Hill', N'Moneyball', 0, 799)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actress in a leading role', N'Charlize Theron', N'Monster', 1, 234)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actress in a leading role', N'Halle Berry', N'Monster''s Ball', 1, 544)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actress in a leading role', N'Nicole Kidman', N'Moulin Rouge', 0, 1133)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actress in a leading role', N'Judi Dench', N'Mrs. Henderson Presents', 0, 816)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actor in a supporting role', N'Kenneth Branagh', N'My Week with Marilyn', 0, 879)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actress in a leading role', N'Michelle Williams', N'My Week with Marilyn', 0, 1088)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actress in a supporting role', N'Marcia Gay Harden', N'Mystic River', 0, 974)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actor in a leading role', N'Sean Penn', N'Mystic River', 1, 1345)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actor in a supporting role', N'Tim Robbins', N'Mystic River', 1, 1443)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actress in a supporting role', N'Pen_lope Cruz', N'Nine', 0, 1185)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actor in a supporting role', N'Javier Bardem', N'No Country for Old Men', 1, 693)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actress in a leading role', N'Charlize Theron', N'North Country', 0, 235)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actress in a supporting role', N'Frances McDormand', N'North Country', 0, 430)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actress in a supporting role', N'Cate Blanchett', N'Notes on a Scandal', 0, 205)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actress in a leading role', N'Judi Dench', N'Notes on a Scandal', 0, 817)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actress in a supporting role', N'Patricia Clarkson', N'Pieces of April', 0, 1154)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actor in a leading role', N'Johnny Depp', N'Pirates of the Caribbean: The Curse of the Black Pearl', 0, 792)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actor in a leading role', N'Ed Harris', N'Pollock', 0, 356)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actress in a supporting role', N'Marcia Gay Harden', N'Pollock', 1, 973)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actress in a leading role', N'Gabourey Sidibe', N'Precious: Based on the Novel ''Push'' by Sapphire', 0, 441)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actress in a supporting role', N'Mo''Nique', N'Precious: Based on the Novel ''Push'' by Sapphire', 1, 1105)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actress in a leading role', N'Keira Knightley', N'Pride & Prejudice', 0, 875)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actor in a leading role', N'Geoffrey Rush', N'Quills', 0, 468)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actress in a leading role', N'Nicole Kidman', N'Rabbit Hole', 0, 1135)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actress in a leading role', N'Anne Hathaway', N'Rachel Getting Married', 0, 77)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actor in a leading role', N'Jamie Foxx', N'Ray', 1, 664)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actress in a leading role', N'Ellen Burstyn', N'Requiem for a Dream', 0, 389)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actor in a supporting role', N'Michael Shannon', N'Revolutionary Road', 0, 1081)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actor in a supporting role', N'Paul Newman', N'Road to Perdition', 0, 1173)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actor in a supporting role', N'Ben Kingsley', N'Sexy Beast', 0, 136)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actor in a supporting role', N'Willem Dafoe', N'Shadow of the Vampire', 0, 1520)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actor in a supporting role', N'Thomas Haden Church', N'Sideways', 0, 1439)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actress in a supporting role', N'Virginia Madsen', N'Sideways', 0, 1490)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actor in a leading role', N'Bradley Cooper', N'Silver Linings Playbook', 0, 169)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actress in a supporting role', N'Jacki Weaver', N'Silver Linings Playbook', 0, 633)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actress in a leading role', N'Jennifer Lawrence', N'Silver Linings Playbook', 1, 718)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actor in a supporting role', N'Robert De Niro', N'Silver Linings Playbook', 0, 1263)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actress in a leading role', N'Diane Keaton', N'Something''s Gotta Give', 0, 323)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actor in a leading role', N'Johnny Depp', N'Sweeney Todd The Demon Barber of Fleet Street', 0, 794)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actor in a supporting role', N'George Clooney', N'Syriana', 1, 476)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actress in a supporting role', N'B_r_nice Bejo', N'The Artist', 0, 140)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actor in a leading role', N'Jean Dujardin', N'The Artist', 1, 697)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actor in a supporting role', N'Casey Affleck', N'The Assassination of Jesse James by the Coward Robert Ford', 0, 201)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actor in a supporting role', N'Alan Alda', N'The Aviator', 0, 19)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actress in a supporting role', N'Cate Blanchett', N'The Aviator', 1, 204)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actor in a leading role', N'Leonardo DiCaprio', N'The Aviator', 0, 926)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actress in a leading role', N'Sandra Bullock', N'The Blind Side', 1, 1336)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actress in a supporting role', N'Rachel Weisz', N'The Constant Gardener', 1, 1219)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actor in a supporting role', N'Jeff Bridges', N'The Contender', 0, 706)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actress in a leading role', N'Joan Allen', N'The Contender', 0, 740)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actor in a supporting role', N'Alec Baldwin', N'The Cooler', 0, 32)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actor in a leading role', N'Brad Pitt', N'The Curious Case of Benjamin Button', 0, 167)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actress in a supporting role', N'Taraji P. Henson', N'The Curious Case of Benjamin Button', 0, 1420)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actor in a supporting role', N'Heath Ledger', N'The Dark Knight', 1, 551)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actor in a supporting role', N'Mark Wahlberg', N'The Departed', 0, 995)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actor in a leading role', N'George Clooney', N'The Descendants', 0, 479)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actress in a leading role', N'Meryl Streep', N'The Devil Wears Prada', 0, 1063)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actress in a supporting role', N'Amy Adams', N'The Fighter', 0, 45)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actor in a supporting role', N'Christian Bale', N'The Fighter', 1, 245)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actress in a supporting role', N'Melissa Leo', N'The Fighter', 1, 1042)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actress in a leading role', N'Rooney Mara', N'The Girl with the Dragon Tattoo', 0, 1301)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actress in a supporting role', N'Jessica Chastain', N'The Help', 0, 724)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actress in a supporting role', N'Octavia Spencer', N'The Help', 1, 1142)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actress in a leading role', N'Viola Davis', N'The Help', 0, 1489)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actor in a supporting role', N'Ed Harris', N'The Hours', 0, 357)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actress in a supporting role', N'Julianne Moore', N'The Hours', 0, 830)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actress in a leading role', N'Nicole Kidman', N'The Hours', 1, 1134)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actor in a leading role', N'Jeremy Renner', N'The Hurt Locker', 0, 721)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actress in a leading role', N'Naomi Watts', N'The Impossible', 0, 1120)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actress in a leading role', N'Meryl Streep', N'The Iron Lady', 1, 1066)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actress in a leading role', N'Annette Bening', N'The Kids Are All Right', 0, 87)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actor in a supporting role', N'Mark Ruffalo', N'The Kids Are All Right', 0, 994)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actor in a leading role', N'Colin Firth', N'The King''s Speech', 1, 273)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actor in a supporting role', N'Geoffrey Rush', N'The King''s Speech', 0, 469)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actress in a supporting role', N'Helena Bonham Carter', N'The King''s Speech', 0, 560)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actor in a leading role', N'Forest Whitaker', N'The Last King of Scotland', 1, 426)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actor in a supporting role', N'Ken Watanabe', N'The Last Samurai', 0, 877)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actor in a supporting role', N'Christopher Plummer', N'The Last Station', 0, 249)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actress in a leading role', N'Helen Mirren', N'The Last Station', 0, 558)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actor in a supporting role', N'Ian McKellen', N'The Lord of the Rings: The Fellowship of the Ring', 0, 584)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actor in a supporting role', N'Stanley Tucci', N'The Lovely Bones', 0, 1393)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actress in a supporting role', N'Amy Adams', N'The Master', 0, 46)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actor in a leading role', N'Joaquin Phoenix', N'The Master', 0, 759)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actor in a supporting role', N'Philip Seymour Hoffman', N'The Master', 0, 1210)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actor in a supporting role', N'Woody Harrelson', N'The Messenger', 0, 1539)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actor in a leading role', N'Adrien Brody', N'The Pianist', 1, 4)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actor in a leading role', N'Will Smith', N'The Pursuit of Happyness', 0, 1518)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actress in a leading role', N'Helen Mirren', N'The Queen', 1, 557)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actor in a leading role', N'Michael Caine', N'The Quiet American', 0, 1072)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actress in a leading role', N'Kate Winslet', N'The Reader', 1, 855)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actress in a leading role', N'Laura Linney', N'The Savages', 0, 899)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actress in a supporting role', N'Helen Hunt', N'The Sessions', 0, 554)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actor in a leading role', N'Jesse Eisenberg', N'The Social Network', 0, 723)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actor in a supporting role', N'Jeremy Renner', N'The Town', 0, 722)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actor in a leading role', N'Richard Jenkins', N'The Visitor', 0, 1250)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actress in a supporting role', N'Marisa Tomei', N'The Wrestler', 0, 990)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actor in a leading role', N'Mickey Rourke', N'The Wrestler', 0, 1093)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2007, N'actor in a leading role', N'Daniel Day-Lewis', N'There Will Be Blood', 1, 287)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actress in a supporting role', N'Holly Hunter', N'Thirteen', 0, 570)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actor in a leading role', N'Gary Oldman', N'Tinker Tailor Soldier Spy', 0, 450)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actor in a supporting role', N'Benicio Del Toro', N'Traffic', 1, 138)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actor in a leading role', N'Denzel Washington', N'Training Day', 1, 313)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2001, N'actor in a supporting role', N'Ethan Hawke', N'Training Day', 0, 407)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actress in a leading role', N'Felicity Huffman', N'Transamerica', 0, 423)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actor in a supporting role', N'Robert Downey Jr.', N'Tropic Thunder', 0, 1267)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actress in a supporting role', N'Hailee Steinfeld', N'True Grit', 0, 540)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actor in a leading role', N'Jeff Bridges', N'True Grit', 0, 708)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2002, N'actress in a leading role', N'Diane Lane', N'Unfaithful', 0, 327)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actress in a supporting role', N'Anna Kendrick', N'Up in the Air', 0, 65)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actor in a leading role', N'George Clooney', N'Up in the Air', 0, 478)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2009, N'actress in a supporting role', N'Vera Farmiga', N'Up in the Air', 0, 1482)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actor in a leading role', N'Peter O''Toole', N'Venus', 0, 1201)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2004, N'actress in a leading role', N'Imelda Staunton', N'Vera Drake', 0, 586)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2008, N'actress in a supporting role', N'Pen_lope Cruz', N'Vicky Cristina Barcelona', 1, 1184)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2006, N'actress in a leading role', N'Pen_lope Cruz', N'Volver', 0, 1183)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actor in a leading role', N'Joaquin Phoenix', N'Walk the Line', 0, 758)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2005, N'actress in a leading role', N'Reese Witherspoon', N'Walk the Line', 1, 1229)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2011, N'actor in a supporting role', N'Nick Nolte', N'Warrior', 0, 1130)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2003, N'actress in a leading role', N'Keisha Castle-Hughes', N'Whale Rider', 0, 876)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actress in a leading role', N'Jennifer Lawrence', N'Winter''s Bone', 0, 717)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2010, N'actor in a supporting role', N'John Hawkes', N'Winter''s Bone', 0, 776)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2000, N'actress in a leading role', N'Laura Linney', N'You Can Count on Me', 0, 897)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (2012, N'actress in a leading role', N'Jessica Chastain', N'Zero Dark Thirty', 0, 725)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (1952, N'actress in a supporting role', N'Colette Marchand', N'Moulin Rouge', 0, 271)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (1952, N'actor', N'Jos_ Ferrer', N'Moulin Rouge', 0, 802)
GO
INSERT [dbo].[oscar_nominees] ([year], [category], [nominee], [movie], [winner], [id]) VALUES (1969, N'actor', N'John Wayne', N'True Grit', 1, 791)
GO