Solution:
select count(*) as n_movies_by_abi from oscar_nominees where nominee='Abigail Breslin';
Output:
SQL Script:
CREATE TABLE [dbo].[oscar_nominees](
[year] [int] NULL,
[category] [nvarchar](50) NULL,
[nominee] [nvarchar](50) NULL,
[movie] [nvarchar](50) NULL,
[winner] [bit] NULL,
[id] [int] NULL
) ON [PRIMARY]
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 (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 (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