My issue
solve the question
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 */
-- Adding an Email column to the employee table
ALTER TABLE employee ADD Email VARCHAR(255);
-- Inserting values including email addresses
INSERT INTO employee (Id, Name, Age, Address, Email) VALUES
(1, 'John Smith', 25, '123 Main St', 'john@example.com'),
(2, 'Sarah Johnson', 30, '456 Broadway', 'sarah@example.com');
-- Selecting all columns from the employee table
SELECT * FROM employee;
Learning course: 212CSE2305: Database Management Systems
Problem Link: https://www.codechef.com/learn/course/kl-dbms-cs-2024/KLDBMS2409/problems/GSQ06