A higher resolution is required to access the IDE
- 192
Learning Opportunities
This puzzle can be solved using the following concepts. Practice using these concepts and improve your skills.
Statement
Goal
In this puzzle, instead of writing an SQL query, you will receive an SQL query and respond to it, acting as a simple database.Your inputs are a basic SQL table and a
For simplicity there are no commands to manipulate tables and only one table to select from. Nothing more advanced than
Basic structure of query is as follows:
Slightly more advanced query example:
Image source: https://unsplash.com/photos/PkbZahEG2Ng
Input
Line 1: A string containing the query you need to parse.
Line 2: An integer rows for the number of table entries.
Line 3: A string representing the header of the table, containing the column names separated by space.
Next rows lines: A string representing the values for each column, separated by space.
Line 2: An integer rows for the number of table entries.
Line 3: A string representing the header of the table, containing the column names separated by space.
Next rows lines: A string representing the values for each column, separated by space.
Output
Line 1: A string representing the header of the output, containing the selected column names separated by space.
Following lines: A string representing the values for each selected column, separated by space.
Following lines: A string representing the values for each selected column, separated by space.
Constraints
2 ≤ initial number of columns ≤ 10
2 ≤ initial number of rows ≤ 30
If any of the values in a column is numeric, then they will all be numeric.
2 ≤ initial number of rows ≤ 30
If any of the values in a column is numeric, then they will all be numeric.
Example
Input
SELECT * FROM cats 3 Name Breed McFur Peterbald Squeeky Bambino Greta Laperm
Output
Name Breed McFur Peterbald Squeeky Bambino Greta Laperm
A higher resolution is required to access the IDE