際際滷

際際滷Share a Scribd company logo

Query tasks

Download as PPTX, PDF
A
Andrew Willetts

The document outlines 3 tasks: 1) Create a query to find all games suitable for a 7 year old by filtering for games rated 3+, 2) Create a query to list all Playstation games in alphabetical order by name, 3) Create a query to find all role-playing games (RPGs) suitable for ages 11+ in stock.

1 of 4
Download to read offline
Query tasks
Task 1 A customer is looking for a game that is suitable for their 7 year old son, create a query that finds all games that are 3+
Task 2 Your manager has requested a list of all Playstation games in alphabetical order of name. Create this query and see if you can work out how to sort them.
Task 3 You have a customer that is looking for an RPG game that is suitable for 11+. Use these facts to create a query that will come back with all the stock you have.

More Related Content

Query tasks

  • 2. Task 1 A customer is looking for a game that is suitable for their 7 year old son, create a query that finds all games that are 3+
  • 3. Task 2 Your manager has requested a list of all Playstation games in alphabetical order of name. Create this query and see if you can work out how to sort them.
  • 4. Task 3 You have a customer that is looking for an RPG game that is suitable for 11+. Use these facts to create a query that will come back with all the stock you have.