OPERATORS

 CREATE DATABASE students;

USE students;

CREATE TABLE info(id int primary key,name varchar(90),address varchar(199), marks int, grade varchar(10));

INSERT INTO info(id,name,address,marks,grade)

values(1,'abhi','kmm',80,'A'),

(2,'bharath','hyd',75,'A'),

(3,'ash','kmr',79,'A'),

(11,'viany','kmr',88,'A'),

(4,'joe','us',89,'A'),

(5,'katy','mum',69,'B'),

(69,'dani','kmm',56,'C'),

(6,'lana','kmm',33,'F'),

(7,'thala','jrknd',100,'O'),

(8,'jaddu','guj','97','O'),

(10,'god','mumbai','100','O'),

(18,'king','delhi',100,'O'),

(45,'shana','mumbai',87,'A'),

(17,'alien','ban',199,'F');

USE students;

SHOW TABLES;

SELECT * FROM info;

SELECT * FROM info WHERE marks+10>100;

SELECT * FROM info WHERE marks%10>6;

SELECT * FROM info WHERE marks>77 AND grade ='A';

SELECT * FROM info WHERE marks>75 AND address='kmm';

SELECT * FROM info WHERE address IN ('kmm','kmr');

SELECT * FROM info WHERE marks BETWEEN 75 AND 99;

SELECT * FROM info where grade='F';

SELECT * FROM info WHERE address NOT IN ('hyd','kmm','kmr');

SELECT * FROM info WHERE marks>69 LIMIT 3;

SELECT id,marks FROM info LIMIT 5;

SELECT * FROM info ORDER BY marks DESC LIMIT 5;

SELECT address,grade FROM info ORDER BY marks ASC LIMIT 7;