Database

create database DIU


create table basic(id int, name varchar(25),gender varchar(25),birthdate varchar(25),hometown varchar(25))
 insert into basic(id,name,gender,birthdate,hometown)
values(10121,'mamum','male','22-01-1995','rajshahi'),
(10453,'nitin','male','24-05,1997','feni'),
(10124,'sadia','female','15-09,1996','netrokona'),
(10563,'salma','female','02-03,1997','manikgonj'),
(10673,'shoriful','male','14-04,1996','comilla')


create table waiver(id int,semester varchar(25),result float,waiver float )
insert into waiver(id,semester,result,waiver)
values(10453,'spring20',3.94,30),
(10124,'spring20',3.88,20),
(10763,'spring20',4.00,50)



 select * from waiver  where waiver not in (30)

  select * from basic  where name like '%i_'  search from last
    select * from basic  where name like '_i%' search from front

      select * from basic  where name like '____m' size 5 and ends with m


create table course(serial int ,course varchar(25),credit int)
insert into course(serial,course,credit)
values(10453,'DBMS',3),
(10763,'DBMS Lab',1),
(9799,'DBMS',1)


select * from basic
select * from waiver
select * from course

select name,waiver,result,birthdate from basic,waiver where basic.id=waiver.id and basic.id=10453 and waiver.id =10453