Praktek SQL 2
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','1980/04/12','Jl. Gondang Manis','0291-5546738','Pria','Firman001@gmail.com') insert into supplier values('sup002','Joko Waluyo','1979/03/07','Jl.Bumi Winosari','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','Farid Yuliyanto','1997/07/18','Jl. Krandon','0291-657457','Pria','Farid@gmail.com') insert into supplier values('sup0