LAPORAN PRAKTIKUM

create database persediaan

use persediaan

create table barang(

       kdbarang char(4),

       Nama_brg varchar(30),

       Jumlah int)

select*from barang

insert into barang values('B001','Buku','10')

insert into barang values('B002','Pulpen','9')

insert into barang values('B003','Spidol','15')

insert into barang values('B004','Penggaris','21')

select count (*) from barang

select avg (jumlah) from barang

select max (jumlah) from barang

select min (jumlah) from barang

select floor(-496.45)

select floor($49.45)

select Round (224.9980,1)

select Round (224.9980,2)

select Round (224.9980,3)

select Round (224.9980,4)