My issue
The Query written in the console is trying to insert data to the table employee.
Debug this query to output the entire table.
Your table is named ‘employee’ and has the following columns
Id (INT)
Name (TEXT),
Age (INT),
Address (TEXT)
My code
-- Insert data into the employee table
INSERT INTO employee (Id, Name, Age, Address)
VALUES (1, 'John Doe', 30, 'New York');
-- Output the entire table
SELECT *
FROM employee;
Learning course: Database management systems
Problem Link: https://www.codechef.com/learn/course/city-dbms/CITYDBMS09/problems/GSQ06