input.txt

create table students(  Name varchar(20) not null,Roll int not null,Age int default 20);
insert into students(Name,Roll) values("Ayush",5);
INSERT INTO students (Name,Roll,Age) values ("Atharva",2,19);
insert into students values ("Pranav",19,20);
insert into students values ("Vidya",23,14);
insert into students values ("Chester",40,41);
insert into students values ("Disha",10,21);
insert into students (name,Roll,Age) values ("John",10,25);
insert into students (Roll, Age) values (10,18);
select * from students where Name in (select Name from students where Roll>15);
select * from students;
select Name as FName, Roll as ID from students where ID in (5,19);
select Name from students where Roll>3 and Age not in(19,41);
create table nick(name varchar(20) not null,title varchar(20));
insert into nick values("Ayush","Kumar");
insert into nick (title,name)values("Bennington","Chester");
insert into nick values("Vidya","Balan");
select * from nick;
drop table nick;
select * from nick;
exit;