Tugas ke-2

create database "201553080"
use "201553080"

create table Supplier(
kdsup varchar(10) primary key,
nmsup varchar(50),
tgllhr date,
alamatkantor varchar(50),
telpkantor varchar(15),
jekel varchar(15),
email varchar(20))

select * from Supplier

insert into Supplier
values ('Sup001',' Firman Ilahudin','12/04/1980','Jl. Gondang Manis','0291-5546738','Pria','Firman001@gmail.com')
insert into Supplier
values('Sup002','Joko Waluyo','07/03/1979','Jl. Bumi Wonosari','024-889772','Pria','Jwal@gmail.com')
insert into Supplier
values('Sup003','Ilham Wahid','1982/08/19','Jl. Dersalam','0291-889324','Pria','Wahid@gmail.com')
insert into Supplier
values ('Sup004','Diah','1994/06/18','Jl. Ganesa Jepara','0291-221345','Wanita','Diah@gmail.com')
insert into Supplier
values ('Sup005','Andre','1998/02/12','Jl. Kaliwungu Kudus','0921-009891','Pria','Andre@gmail.com')
insert into Supplier
values ('Sup006','Tere','1992/12/31','Jl. Bae Kudus','0291-987234','Wanita','Tere@gmail.com')
insert into Supplier
values ('Sup007','Agung','1994/02/14','Jl. Puncakwangi Pati','0291-111231','Pria','Agung@gmail.com')
insert into Supplier
values ('Sup008','Dila','1999/04/23','Jl. Dawe Kudus','0291-080165','Wanita','Dila@gmail.com')
insert into Supplier
values ('Sup009','Lia','1999/07/17','Jl. Mayong Jepara','0291-763451','Wanita','Lia@gmail.com')
insert into Supplier
values ('Sup010','Dila','1998/09/13','Jl. Singocandi Kudus','0291-298015','Pria','Dila@gmail.com')

select*from Supplier where alamatkantor='Jl. Dersalam'
select email from Supplier where alamatkantor='Jl. Gondang Manis'
select*from Supplier where alamatkantor='Semarang'
select*from Supplier where tgllhr='1994/02/14'
select*from Supplier where tgllhr='1998/09/13'
select email from Supplier where alamatkantor='Jl. Bae Pati'
select alamatkantor, telpkantor from Supplier where nmsup like '%Diah%'
select alamatkantor, telpkantor from Supplier where nmsup like '%Andre%'
select*from Supplier where jekel='Wanita'
select telpkantor,email from Supplier where alamatkantor='Jl. Singocandi Kudus'