Help me in solving GSQ54 problem

help
,
1

Problem Link: CodeChef: Practical coding for everyone
Learning course: Learn SQL

My code

/* Solution as follows */
create table customer(Id INT,Name TEXT,Age INT,Address TEXT);

ALTER TABLE customer
ADD COLUMN email TEXT;
INSERT INTO customer(Id,Name,Age,Address,email)
VALUES(1, 'John Smith', 25,  'Main St','john@ex.com'),
(2, 'Sarah Johnson', 30,'Broadway','sarah@ex.com');

select  * from customer;

My issue

2

Problem Link: CodeChef: Practical coding for everyone
Learning course: Learn SQL

My code

/* Solution as follows*/
CREATE TABLE employee(
    employee_id INT,
    employee_Name TEXT,
    Department TEXT
);
/*Lets add the details of 2 employees to the table 'employee' */

INSERT INTO employee (employee_id,employee_Name,Department)
VALUES (4,'Marcus Garcia','Product'),
       (5,'Samantha Park','Hr');

My issue

3

Problem Link: CodeChef: Practical coding for everyone
Learning course: Learn SQL

My code

/*Click on Submit to check the output.
Click on Next to proceed */

select * from employee;

My issue

4

Problem Link: CodeChef: Practical coding for everyone
Learning course: Learn SQL

My code

select * from employee;

My issue

SIGHUP
Parse error near line 4: no such table: employee

5

@yashraj_tarte - Hey - this is rectified. There was an internal bug at our end.

6

@suhaskatkuri - Hey - this is rectified. There was a bug at our end.

7

Problem Link: CodeChef: Practical coding for everyone
Learning course: SQL at Work

My code

/* Solution as follows */

-- Revenue in 'Jul' for 'Low_Margin' 'Menswear' needs to be updated to 25000
UPDATE Financials 
SET revenue = 25000
WHERE month = 'Jul' and (division = 'Menswear' and product_type = 'Low_Margin');

-- Revenue in 'Aug' for 'New_Products' 'Womenswear' needs to be updated to 10000
UPDATE Financials 
SET revenue = 10000
WHERE month = 'Aug' and (division = 'Womenswear' and product_type = 'New_Products');

-- Output all entries of the 2 rows updated above
SELECT * FROM Financials
WHERE (month = 'Jul' and division = 'Menswear' and product_type = 'Low_Margin')
OR (month = 'Aug' and division = 'Womenswear' and product_type = 'New_Products');

My issue

It shows error for the table financials

8

Problem Link: CodeChef: Practical coding for everyone
Learning course: Learn SQL

My code

-- SELECT * FROM Flights
-- WHERE Gender = 'Female' AND Destination = 'Cairo';
/* Solution as follows */

select * from Flights
where destination = 'Cairo'
and gender =  'Female';

My issue