You should submit your answers in word processed form ONLY. Ensure that each answer is clearly numbered and labelled (e.g. 10.1: List all female students).

You should also take care to check your answers by implementing them in Access. Do NOT submit Access screenshots or printouts for marking.

The tables used in these questions are STUDREC and CARS.

Ensure that you always include sufficient columns to ensure that your output is meaningful and in any case always include studrec.init and studrec.sname.

What SQL statements would you use to achieve the following output?

1: List all female students

2: List all students who's family name begins with 'M'.

3: List all students who have between 1 and 2 children (inclusive).

4: List all students in order of their home town

5: List all students from Barnsley who have children

6: List all students who were born in the 1960's

7: List only those students who own cars

8: List all Huddersfield students who own cars

9: List all students who own yellow, red, black or blue cars

10: List all students and all of the cars, showing who owns which cars