Tugas ke-2

create database "201553043"
use "201553043"

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','Agus','1997/07/08','Jl. Mayong Jepara','0291-002123','Pria','Agus@gmail.com')
insert into Supplier
values ('Sup005','Tomi','1996/12/24','Jl. Klumpit Kudus','0921-876954','Pria','Tomi@gmail.com')
insert into Supplier
values ('Sup006','Dian','1995/10/12','Jl. Glantengan Kudus','0291-234133','Pria','Dian@gmail.com')
insert into Supplier
values ('Sup007','Fahrul','1997/07/12','Jl. Puncakwangi Pati','0291-999543','Pria','Fahrul@gmail.com')
insert into Supplier
values ('Sup008','Angga','1997/04/21','Jl. Ganesa Pati','0291-085432','Pria','Ngangge@gmail.com')
insert into Supplier
values ('Sup009','Riski','1998/04/02','Jl. Nalumsari Jepara','0291-113638','Pria','Kiekiy@gmail.com')
insert into Supplier
values ('Sup010','Ade','1997/04/02','Jl. Agil Kusumadya Kudus','0291-012521','Pria','Ade@gmail.com')


1. Tampilkan Data Supplier yang kantornya daerah Dersalam
select*from Supplier where alamatkantor='Jl. Dersalam'
2. Tampilkan Data Email Supplier yang kantornya daerah gondangmanis
select email from Supplier where alamatkantor='Jl. Gondang Manis'
3. Tampilkan Data Supplier yang kantornya daerah Semarang
select*from Supplier where alamatkantor='Semarang'
4. Tampilkan Data Supplier yang lahir pada tanggal 02 April 1998
select*from Supplier where tgllhr='1998/04/02'
5. Tampilkan Kode Supplier dan Nama Supplier yang kantornya daerah Klumpit Kudus
select kdsup,nmsup from Supplier where alamatkantor='Jl. Klumpit Kudus'
6. Tampilkan Email Supplier yang kantornya daerah Puncakwangi Pati
select email from Supplier where alamatkantor='Jl. Puncakwangi Pati'
7. Tampilkan Alamat kantor dan telp kantor yang namanya Tomi, Dian dan Ade
select alamatkantor, telpkantor from Supplier where nmsup like '%Tomi%' or nmsup like '%Dian%' or nmsup like '%Ade%'
8. Tampilkan Data Supplier yang berjenis kelamin pria
select*from Supplier where jekel='Pria'
9. Tampilkan Data Supplier yang berjenis kelamin wanita
select*from Supplier where jekel='Wanita'
10. Tampilkan telp kantor dan email supplier yang daerahnya bumi wonosari

select telpkantor,email from Supplier where alamatkantor='Jl. Bumi Wonosari'