SQL Silver Quiz

What would the following SQL statement do? SELECT * FROM Pupils

Answer explanation

It would display all records from the Pupils table.

What would the following SQL statement do? SELECT Age FROM Pupils

Answer explanation

It would display the age of all records in the Pupils table.

What would the following SQL statement do? SELECT forename, surname, age FROM Pupils

Answer explanation

It would display the forename, surname and age of all the records in the Pupils table.

What would the following SQL statement do? SELECT * FROM Pupils WHERE gender = "Female"

Answer explanation

It would display all the records from the Pupils table who are female.

What would the following SQL statement do? SELECT forename, surname FROM Pupils WHERE age <= 12

Answer explanation

It would display the forename and surname from all the records in the Pupils table who are age 12 or younger.

What would the following SQL statement do? SELECT forename, surname FROM Pupils WHERE age = 12 AND gender = "Male"

Answer explanation

It would display the forename and surname from all the records in the Pupils table who are 12 years old and male.

What would the following SQL statement do? SELECT * FROM Pupils WHERE age = 12 OR gender = "Female"

Answer explanation

It would display all the records from the Pupils table who are 12 years old and display all the records that are females.

What would the following SQL statement do? SELECT * FROM Pupils ORDER BY age

Answer explanation

It would display all the records from the Pupils table but would have them in ascending order by age (youngest to oldest).

What would the following SQL statement do? SELECT forename, surname FROM Pupils ORDER BY age DESC

Answer explanation

It would display the forename and surnames from all the records in the Pupils table but it would have them in descending order by age (oldest to youngest).