CREATE TABLE details(
    customer_id int,
    cust_name varchar(20),
    city varchar(20),
    grade float,
    salesman_id int
    )
INSERT INTO details
VALUES(3007,'Brad Davis','New York', 200,5001);
INSERT INTO details
VALUES(3005,'Graham Zusi','California', 200,5002);
INSERT INTO details
VALUES(3008,'Julian Green','London', 300,5002);
INSERT INTO details
VALUES(3004,'Fabian Johnson','Paris', 300,5006);
INSERT INTO details
VALUES(3009,'Geoff Cameron','berlin', 100,5003);
INSERT INTO details
 VALUES(3003,'Jozy Altidor','Moscow', 200,5007)
    
1>>    SELECT* from details
WHERE grade>100;


2>>	SELECT* from details
WHERE city='New York';
3>>	SELECT* from details
WHERE city='New York' AND grade>100;

4>> SELECT* from details
WHERE city='New York' OR grade>100;

5>>	 SELECT* from details
WHERE city='New York' OR 
NOT grade>100;

6>>	SELECT* from details
WHERE NOT city='New York' OR 
NOT grade>100;

7>> SELECT* from details
WHERE  city='London'
AND grade=300;
UPDATE details
 set  grade=250
WHERE  city='London'
AND grade=300;

a>>   SELECT * FROM `details`
WHERE salesman_id=5001;

b>>SELECT cust_name , city   FROM `details`
WHERE city='Paris'
c>>	 SELECT cust_name , city ,salesman_id  FROM `details`
WHERE city='Paris' or city='Berlin'