Tugas Pemrograman SQL Kelas C
Nama : Galeh Raka Siwi
NIM :201553073
Kelas : PSQL-C

Data dari semua data




















a. Tampilkan Data Supplier yang kantornya daerah Dersalam









b.Tampilkan Data Supplier yang rumahnya daerah gondangmanis








c.Tampilkan Data Supplier yang rumahnya daerah Semarang










Berikut adalah Script/Query dari Data Diatas :

create database "201553073"
use "201553073"
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','Galeh Raka Siwi ','08/11/1994','Jl.Pati Tayu','0291-5546739','Pria','galeh64@gmail.com')
insert into Supplier values ('Sup005','Fredo Maulana Putra','01/08/1997','Jl.Perum Terban','0291-5546740','Pria','fredomaula@gmail.com')
insert into Supplier values ('Sup006','Dwi Sari Apriyani','04/10/1997','Jl.Semarang','0291-5546741','Wanita','sariiay@gmail.com')
insert into Supplier values ('Sup007','Nafiuddin','10/07/1996','Jl.Menara Kudus','0291-5546723','Pria','nafnaf11@gmail.com')
insert into Supplier values ('Sup008','Dian Tri Raharjo','03/05/1997','Jl.Menara Kudus','0291-5546654','Pria','Diantoi12@gmail.com')
insert into Supplier values ('Sup009','Nishrina Ainiyatul M','07/08/1997','Jl.Jati','0291-5546445','Wanita','nishrina32@gmail.com')
insert into Supplier values ('Sup010','Dita Widyastuti','04/04/1994','Jl.Jepara Kudus','0291-5546777','Wanita','Ditachibi48gmail.com')
select * from Supplier where Alamatkantor='Jl.Dersalam'
select * from Supplier where Alamatkantor='Jl.Gondang Manis'
select * from Supplier where Alamatkantor='Jl.Semarang'