SQL : Contoh Penggunaan Klausa "between" di SQL

 create database latihan
use latihan

create table barang
(
kode_brg varchar(5),
nama_brg varchar(15),
jumlah integer,
harga integer,
asal_supplier varchar(20)
)

insert into barang
    values('01','Mie','10','1000','Denpasar')
insert into barang
    values('02','Gula','30','7000','Banyuwangi')
insert into barang
    values('03','Keju','25','10000','Jakarta')
insert into barang
    values('04','Susu','20','35000','Jakarta')
insert into barang
    values('05','Kopi','80','9000','Denpasar')
insert into barang
    values('06','Teh','15','2000','Surabaya')
insert into barang
    values('07','Roti','40','5000','Bandung')

select nama_brg from barang where jumlah between 10 and 50
select nama_brg from barang where harga between 2000 and 5000