There are new employees that need to be added to the Employees table. Here is their data: Firstname: Wang Lastname: Lee Sala

Question

this my code

INSERT INTO Employees(firstname, lastname,
salary)
VALUES ("Wang" , "Lee" , 1900),
("Greta" , "Wu" , 1200);

SELECT id, firstname, lastname, salary
FROM Employees
ORDER BY id DESC

but it shows this error
ERROR: column "Wang" does not exist
LINE 3: VALUES ("Wang" , "Lee" , 1900),
^

Answer 1

Nipun Deshappriya May be typo mistake as error show in line 3 check Wang check again.

Answer 2

This code does produce result in a SQLite 3.37.0 environment:

CREATE TABLE Employees (
id INT PRIMARY KEY,
firstname VARCHAR,
lastname VARCHAR,
salary INT);

INSERT INTO Employees
(firstname, lastname, salary)
VALUES
("Wang", "Lee", 1900),
("Greta", "Wu", 1200);

SELECT id, firstname, lastname, salary
FROM Employees
ORDER BY id DESC;

Answer 3

insert into Employees( firstname, lastname, salary)
values
('Wang', 'Lee', 1900),
('Greta', 'Wu', 1200);

select id, firstname, lastname, salary from Employees
order by id desc;

Answer 4

insert into Employees( firstname, lastname, salary)
values
('Wang', 'Lee', 1900),
('Greta', 'Wu', 1200);

select id, firstname, lastname, salary from Employees
order by id desc;

Answer 5

no typing errors I double checked

Answer 6

You should put single quotation instead of double quotations.

INSERT INTO Employees(firstname, lastname, salary)
VALUES
('Wang', 'Lee', 1900),
('Greta', 'Wu', 1200);

SELECT id, firstname, lastname, salary
FROM Employees
ORDER BY id DESC;