# Help me in solving GSQ54 problem

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
VALUES(1, 'John Smith', 25,  'Main St','john@ex.com'),

select  * from customer;
``````

### My issue

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

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

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

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

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

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

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';
``````