CREATE DATABASE Task2
CREATE TABLE xyz(
    cutomerid int,
    customername varchar(20),
   city varchar(10),
  grade int,
    salesmanid int
    );
INSERT INTO xyz VALUES(3002,'Nick Rimando','New York',100,5001);
INSERT INTO xyz VALUES(3007,'Brad Davis','New York',200,5001);
INSERT INTO xyz VALUES(3005,'Graham Zusi','California',200,5002);
INSERT INTO xyz VALUES(3008,'Juliam Green','London',300,5002);
INSERT INTO xyz VALUES(3004,'Fabian Johnson','Paris',300,5006);
INSERT INTO xyz VALUES(3009,'Geoff Cameron','Brlin',100,5003);
INSERT INTO xyz VALUES(3003,'Jozy Altidor','Moscow',200,5007); 

SELECT * FROM xyz
WHERE grade>100

SELECT * FROM xyz
WHERE city='New York'

SELECT * FROM xyz
WHERE city='New York'
AND grade>100

SELECT * FROM xyz
WHERE city='New York'
OR grade>100

SELECT * FROM xyz
WHERE city='New York'OR
NOT grade>100