Help me in solving GSQ07 problem

help
,
1

My issue

I write code correct but i dont know why this code is comes like runtime error and it error comes Employee and open paranthesis (

My code

/* Write a query to add the below mentioned employee details to the EMPLOYEE table.
Employee id: 06, Employee Name: Brandon Kim, Department: Operations
*/
create table Employee(Employee_id int,employee_name varchar(30),department varchar(30));
insert Employee details
(1,'kayla thompson','sales'),
(2,'ethan chen','operations'),
(3,'julia lee','hr');
select *from Employee ;

Learning course: Learn SQL
Problem Link: Practice Problem in - CodeChef

2

Hii @swathidurgam

Correct code:

INSERT INTO employee (Employee_id,Employee_Name,Department)
VALUES(6,‘Brandon Kim’,‘Operations’);

No need to create a employee table, it’s already stored in the database, so just insert the columns and its values using the above code.

Thank you, Hope it will helps :grin: pls like if it helps. :blush: