Brainlag PlusWrite your own SQL and run it: SELECT with WHERE, AND, OR, LIKE and ORDER BY, a query over two tables, and INSERT, UPDATE and DELETE, each checked against the tables.
How these questions are marked
In this lesson you write real SQL in the editor.
It runs on the tables in the question, and the tests check what it gives back.
- A query test compares the records your last SELECT returns with the records it should return. Some tests also check the order.
- After an INSERT, UPDATE or DELETE, a test looks at the table to see whether the right records changed and nothing else did.
- Every test starts from a fresh copy of the tables, so you can run your SQL as often as you like.
- Your mark is your share of the tests passed.
Field names and text must match the table exactly. 'drama' is not the same text as 'Drama'.
The rest of this lesson and its 19 practice questions are in Plus.
Screen 1 of 5, free to read.
- 19 exam-style questions, marked as you go, each with a worked solution
- Anything you get wrong is saved to your flashcards