On the Subject of SQL - Basic
How fun is it to ride through a large table of numbers to find similarities...
This module is a SQL code simulator. To disarm it, produce a SQL query that outputs a given result. The input data is in this document, use it to reproduce the given result. Use the documentation to build a SQL query that will reproduce the expected result from the input data.
The Goal button
Press the Goal button to see what results the module expects. The expectation is a table of numbers with anywhere from 1 to 4 rows and 2 to 3 columns. Below are a few examples:
2 | 9 | 6 |
4 | 2 | 1 |
7 | 1 | 4 |
3 | 8 | 2 |
2 | 9 | 6 |
4 | 2 | 1 |
2 | 9 |
4 | 2 |
7 | 1 |
2 | 9 | 6 |
The Check button
Upon pressing the Check button, the module compiles the SQL query and executes it against the input data. The result is compared to the goal table. If it matches, the module is disarmed; otherwise, a strike is registered.