SQL For Actuaries

1. How do you select all records from table Accidents where Gender is "Male" and RiskClass = "C"

SELECT Gender, RiskClass WHERE Gender = "Male" and RiskClass = "C"

SELECT * WHERE Gender = "Male" and RiskClass = "C"

SELECT * FROM Accidents WHERE Gender = "Male" and RiskClass = "C"

SELECT * FROM Accidents WHERE Gender = "Mal" and RiskClas =

About This Quiz

2. What's your name?

We’ll put your name on your report, certificate, and leaderboard.

2. How do you select all columns from a table Accidents where the Gender is Male?

SELECT * FROM Accidents WHERE Gender "Male"

SELECT * FROM Accidents WHERE Gender LIKE "Male"

SELECT * FROM Accidents WHERE Gender "Female"

SELECT * FROM Accidents WHERE Gender = "Male"

3. Which SQL Keyword(s) is used to sort data?

ORDER

SORT BY

SORT

ORDER BY

4. The character '%' in SQL is equivalent to '*' in MS Access. These are known as wildcards. How would you select all the fields from the table Accidents where LastName ends with "son" ?

SELECT * FROM Accidents WHERE LastName = '%son%'

SELECT * FROM Accidents WHERE LastName LIKE '%son'

SELECT * FROM Accidents WHERE LastName LIKE 'son%'

SELECT * FROM Accidents WHERE LastName = 'son'

5. How do you select a column named "RiskClass" from a table named "Accidents"?

SELECT * FROM Accidents

SELECT RiskClass FROM Accidents

SELECT Accidents.RiskClass

SELECT * FROM Accidents WHERE RiskClass