List the details for those movies that are made between 1999 and 2023 -- and their title
Question:
List the details for those movies that are made between 1999 and 2023
-- and their title contains either 'matrix', or 'nice'
-- 2. List the actor number for each actor and the total amount of movie fees
-- they have received for all their roles combined.
-- Only show actors where the total fees are less than $600,000
-- 3. List details for the directors that have ever directed 'Comedy' type movies.
-- Show each director only once and sequence alphabetically by name.
-- 4. List the actor number for the actors that have had at least 2 roles in 2002.
-- 5. List the details of the movies that have been directed by Anthony Minghella
-- and in which Nicole Kidman has had a role. Sequence by movie title.
-- 6. Count the number of different actors that have had roles
-- in 'Comedy' movies made after 1990.
-- 7. List the movie types that have had between 2 and 6 movies made between 1995 and 2010
-- 8. Show the number of roles in 2002 for each actor along with the actor number
-- whose total fees in that year exceeded $50,000
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill