create table passenger2(passportid integer primary key,name varchar(20),age integer,sex char(1),address varchar(30));
create table passengerticket(passportid integer,ticketno integer primary key);
create table reservation2(PNRN integer primary key,journeydate text,noofseats integer,destination varchar(20),busno integer,ticketno integer);
insert into passenger2 values(82302,'Smith',23,'M','Hyderabad');
insert into passenger2 values(82303, 'Neha', 23, 'F', 'Hyderabad');
insert into passenger2 values(82304,'Neha',35,'F','Hyderabad');
insert into passenger2 values(82306,'Ramu',40,'M','Hyderabad');
insert into passenger2 values(82308,'Aakash',40,'M','Hyderabad');
insert into passenger2 values(82402,'Aravind',42,'M','Hyderabad');
insert into passenger2 values(82403,'Avinash',42,'M','Hyderabad');
insert into passenger2 values(82502,'Ramesh',23,'M','Hyderabad'); 
insert into passenger2 values(82602,'Rajesh',23,'M','Hyderabad'); 
insert into reservation2 values(10201,'2012-02-20 10:20:25',05,'HYD',9654,235242); 
insert into reservation2 values(10202,'2012-02-22 10:22:25',05,'HYD',9654,232451);
insert into reservation2 values(10203,'2013-03-22 10:30:25',05,'DELHI',9654,587960);
insert into reservation2 values(10204,'2013-03-22 11:30:25',05,'CHENNAI', 9845,761254); 
SELECT p.name FROM passenger2 p WHERE p.passportid IN (SELECT pt.passportid FROM passengerticket pt);
SELECT t.ticketno, p.name FROM passengerticket t JOIN passenger2 p ON t.passportid = p.passportid;
SELECT name FROM passenger2 WHERE name LIKE 'R%';
SELECT name FROM passenger2 WHERE age BETWEEN 30 AND 45;
SELECT * FROM passenger2 WHERE name LIKE 'A%';
SELECT name FROM passenger2 ORDER BY name;
select * from passenger2 ;
select * from reservation2 ;
select * from passengerticket ;