SUB QUERIES

 CREATE DATABASE students1;

USE students1;

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

INSERT INTO info1(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');

SHOW TABLES;

SELECT name,marks

FROM info1

WHERE marks>

(SELECT AVG(marks) FROM info1);

ALTER TABLE info CHANGE id roll_no INT;

SELECT name,roll_no FROM info WHERE roll_no %2=0; 

SELECT name,roll_no FROM info WHERE 

roll_no IN (SELECT roll_no FROM info WHERE roll_no %2=0);

SELECT MAX(marks) FROM (SELECT * FROM info WHERE address='mumbai') AS temp;

SELECT MAX(marks) FROM info WHERE address='mumbai';

SELECT (SELECT MAX(marks) FROM info)

FROM info;