Copy High Performers
Mediumsql
Copy every employee earning at least 80000 from employees into the (initially empty) high_performers table, matching columns id, name, salary. The checker runs SELECT id, name, salary FROM high_performers ORDER BY id; afterward.
sqlCREATE TABLE employees (id INTEGER PRIMARY KEY, name TEXT NOT NULL, salary INTEGER NOT NULL); CREATE TABLE high_performers (id INTEGER PRIMARY KEY, name TEXT NOT NULL, salary INTEGER NOT NULL);
Sample data (this is the starting state before your statement runs):
sqlINSERT INTO employees (id, name, salary) VALUES (1, 'Asha', 85000), (2, 'Rohan', 62000), (3, 'Neha', 91000);
Example 1
Input
(none)
Output
id name salary 1 Asha 85000 3 Neha 91000
INSERT ... SELECT copies query results directly into another table. Reference: INSERT INTO high_performers (id, name, salary) SELECT id, name, salary FROM employees WHERE salary >= 80000;