My issue
Debug this query
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
/* The Query written in the console is trying to insert data to the table employee.
Debug this query to output the entire table */
-- Insert data into the employee table
INSERT INTO employee (Id, Name, Age, Address)
VALUES (1, 'John Doe', 30, '123 Elm Street');
-- 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