N5+Query+Design+2

media type="custom" key="29533283"

Questions:

Design a query using the layout from the PowerPoint example using the following criteria:

1. List the pupils (first and last name) from the tutor class 3T2 who can pay the piano.

2. List the schools in Edinburgh, in desending order that run the subject Advanced Higher Computing Science.

3. List the hotels (name and number and town) that have at least a 4 star rating, in decending order who have a spa and late checkout of 15.00.