Syntax Engine: SQL
Master precise SQL Query strings using our internal query validator.
Database Target: You are querying the tblStudents table. The fields available are: StudentID, FirstName, Surname, Age, Subject, and Email.
Bronze (Data Target)
Extraction
Write an SQL query to retrieve every single field for all records in the table. Use the wildcard character.
Silver (Constraints)
Identifying Integers
Filter out the noise! Write a query to retrieve the FirstName and Age of all students who are exactly 15 years old.
Gold (The Quotes Trap)
Text Strings
If a field is a Text/String data type, you must query it using proper grammar quotation marks. Write an SQL query to retrieve ONLY the Email of any student studying History.