Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    Search Criteria Tasks

    Uploaded by

    oneinamillionnamedluna
    This document contains instructions for completing 14 query practice tasks in a DVD database. Each task asks a question to retrieve data from the database, such as the number of titles starring a particular actor, released in a certain year, or belonging to a specific genre. The tasks cover a range of filtering criteria like actor, year, genre, rating, length, price and name attributes to practice complex database queries.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    Search Criteria Tasks

    Uploaded by

    oneinamillionnamedluna
    14 views3 pages
    This document contains instructions for completing 14 query practice tasks in a DVD database. Each task asks a question to retrieve data from the database, such as the number of titles starring a particular actor, released in a certain year, or belonging to a specific genre. The tasks cover a range of filtering criteria like actor, year, genre, rating, length, price and name attributes to practice complex database queries.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains instructions for completing 14 query practice tasks in a DVD database. Each task asks a question to retrieve data from the database, such as the number of titles starring a particular actor, released in a certain year, or belonging to a specific genre. The tasks cover a range of filtering criteria like actor, year, genre, rating, length, price and name attributes to practice complex database queries.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    14 views3 pages

    Search Criteria Tasks

    Uploaded by

    oneinamillionnamedluna
    This document contains instructions for completing 14 query practice tasks in a DVD database. Each task asks a question to retrieve data from the database, such as the number of titles starring a particular actor, released in a certain year, or belonging to a specific genre. The tasks cover a range of filtering criteria like actor, year, genre, rating, length, price and name attributes to practice complex database queries.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 3

    Query Practice Tasks

    All tasks are to be performed in the DVD Database


    (Type Answers into Text Boxes then Print)

    Name:

    Task 1
     How many titles in our collection star Bruce Lee?

    Task 2
     How many titles in our collection were made in 1999?

    Task 3
     How many titles of the action genre were made after 2001?

    Task 4
     How many titles were made in 2000 or 2004?

    Task 5
     How many titles of the action genre starred Bruce Willis and were
    rated less than 4?
    Task 6
     How many titles in our collection are in the Sci-Fi or Comedy genre
    and are rated more than or equal to 3?

    Task 7
     How many titles in our collection cost less or equal to £6?
    Note: You don’t need to enter the £ sign when entering the price

    Task 8
     How many titles contain the word ‘The’ and were released in the
    year 2002 or later?

    Task 9
     How many titles are of the horror or thriller genre and cost
    between £4 and £14?

    Task 10
     How many titles star Brad Pitt or Mel Gibson, were rated between
    2 and 4 and have a length of more than 120 minutes?
    Task 11
     How many titles contain the word ‘Future’ and were released after
    1985?

    Task 12
     How many titles were released between 1995 and 2005 and starred
    an actor whose name begins with ‘W’?

    Task 13
     How many titles cost between £4 and £8, are in the horror genre
    and the name of the movie ends with the letter ‘S’?

    Task 14
     How many titles have names that are exactly 7 characters long?

    You might also like