SQL For Actuaries

Question 1 / 6

🏆 Rank #-- ▾

Score 0/100

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

You may optionally provide this to label your report, leaderboard, or certificate.

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"

ORDER

SORT BY

SORT

ORDER BY

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'

SELECT * FROM Accidents

SELECT RiskClass FROM Accidents

SELECT Accidents.RiskClass

SELECT * FROM Accidents WHERE RiskClass

Thank you for your feedback!