← 返回 amazon 的题目列表In-Memory SQL
类型:online_judge
amazon
Design a simple in-memory SQL query interface. The interface should support the following basic functions:
CREATE TABLE table_name (column1 data_type1, column2 data_type2, ...): Create a table.
INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...): Insert a row of data into the table.
SELECT column1, column2, ... FROM table_name WHERE condition: Query data from the table, supporting simple condition queries.
Implement these operations and ensure performance. Given example data and query requirements, return the correct result. You need to consider how your data structures should be designed to support fast insertions and queries.
Example:
CREATE TABLE users (id INT, name STRING, age INT)
INSERT INTO users (id, name, age) VALUES (1, 'Alice', 30)
INSERT INTO users (id, name, age) VALUES (2, 'Bob', 25)
SELECT name FROM users WHERE age > 26
Output: ['Alice']
Example
Input
CREATE TABLE users (id INT, name STRING, age INT)
INSERT INTO users (id, name, age) VALUES (1, 'Alice', 30)
SELECT name FROM users WHERE age > 25