SQL : Contoh Penggunaan Klausa "and" 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 * from barang where jumlah>10 and asal_supplier = 'Jakarta'
Select *from barang where harga< 5000 and asal_supplier='bandung'