nested query route,driver,bus

create table bus(
bus_no integer primary key,
bus_cap integer NOT NULL,
depot_name varchar(20));

insert into bus values(1,'5','kalewadi');
insert into bus values(2,'20','chichwad');

select * from bus;

create table route(
route_no integer primary key,
source varchar(20),
destination varchar(20),
nostation integer);

insert into route values(1,'aundh','warje','2');
insert into route values(2,'pashan','sangvi','4');

select * from route;

create table driver(
d_no integer primary key,
d_name char(20),
lic_no integer,
addr char(20),
d_age integer,
sal float);

insert into driver values(1,'ram','7','kalewadi','29','20000');
insert into driver values(2,'sham','10','warje','35','15000');

select * from driver;