Rabu, 08 Maret 2017

Nama : Fredo Maulana Putra
NIM : 201553045
Kelas : PSQL-B

a.Tampilkan Data Supplier yang kantornya daerah Dersalam


b.Tampilkan Data Email Supplier yang rumahnya daerah gondangmanis



c.Tampilkan Data Supplier yang rumahnya daerah Pati-Tayu











Dan ini Script/Query dari Data Diatas :

create database "201553045"
use "201553045"
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 Ilahuddin','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','11/27/1982','Jl.Dersalam','0291-889324','Pria','Wahid@gmail.com')
insert into Supplier values ('Sup004','Fredo Maulana Putra','08/11/1994','Jl.Perum Terban','0291-5546739','Pria','fredomaula@gmail.com')
insert into Supplier values ('Sup005','Galeh Raka Siwi','01/08/1997','Jl.Pati Tayu','0291-5546740','Pria','galeh64@gmail.com')
insert into Supplier values ('Sup006','M Yusuf Noor H','12/04/1995','Jl.Getas Pejaten','0291-5546741','Pria','yusuf2@gmail.com')
insert into Supplier values ('Sup007','Muh Suhartomie','10/07/1996','Jl.Kudus Jepara','0291-5546742','Pria','tomietomi@gmail.com')
insert into Supplier values ('Sup008','Dian Tri Raharjo','03/05/1997','Jl.Menara Kudus','0291-5546743','Pria','Diantoi12@gmail.com')
insert into Supplier values ('Sup009','Nishrina Ainiyatul M','07/08/1997','Jl.Jati','0291-5546744','Wanita','nishrina32@gmail.com')
insert into Supplier values ('Sup010','Dita Widyastuti','04/04/1994','Jl.Jepara Kudus','0291-5546745','Wanita','Ditachibi48gmail.com')
select * from Supplier where Alamatkantor='Jl.Dersalam'
select * from Supplier where Alamatkantor='Jl.Gondang Manis'
select * from Supplier where Alamatkantor='Jl.Pati Tayu'

Tidak ada komentar:

Posting Komentar