/*Nomor 0*/
select namabarang,stok,hargabeli from tblBarang order by namabarang ASC, hargabeli DESC;
/*Nomor 1*/
select namabarang,stok,hargabeli from tblBarang
where (namabarang LIKE 'A%')OR(namabarang LIKE 'B%')OR(namabarang LIKE 'E%')OR(namabarang LIKE 'F%')
OR(namabarang LIKE 'P%')
order by namabarang ASC,hargabeli DESC;
/*Nomor 2*/
select namabarang,stok,hargabeli from tblBarang
where namabarang not like '%Sti%'AND namabarang not like '%Nugget%'
order by namabarang ASC,hargabeli DESC;
/*Nomor 3*/
select namabarang,stok from tblBarang
where stok<1000
order by namabarang DESC;
/*Nomor 4*/
select namabarang,stok from tblBarang
where stok>=250 AND stok<=400
order by stok ASC;
/*Nomor 5*/
select namabarang as 'NAMA BARANG',stok as 'JUMLAH STOK',hargabeli as 'HARGA BELI',stok*hargabeli as 'MODAL DASAR'
from tblBarang
order by stok*hargabeli ASC;
/*Nomor 6*/
select namabarang as 'NAMA BARANG',stok as 'JUMLAH STOK',hargabeli as 'HARGA BELI',stok*hargajual as 'HASIL PENJUALAN'
from tblBarang
where namabarang like '%Baso%' or namabarang like '%Nugget%' or namabarang like '%Sosis%'
order by stok*hargajual DESC;
/*nomor 7*/
select namabarang as 'NAMA BARANG',stok as 'JUMLAH STOK',hargabeli as 'HARGA BELI',hargajual as 'HARGA JUAL',stok*hargajual as 'HASIL PENJUALAN',stok*hargabeli as 'MODAL DASAR',stok*hargajual-stok*hargabeli as 'LABA'
from tblBarang
order by stok*hargajual-stok*hargabeli DESC;
/*Nomor 8*/
select namabarang as 'NAMA BARANG',stok as 'JUMLAH STOK',hargabeli as 'HARGA BELI',hargajual as 'HARGA JUAL',stok*hargajual as 'HASIL PENJUALAN',stok*hargabeli as 'MODAL DASAR',stok*hargajual-stok*hargabeli as 'LABA'
from tblBarang
where namabarang not like '%Baso%'AND namabarang not like '%Sosis%' AND namabarang not like '%Nugget%'
order by namabarang ASC;
/*Nomor 9*/
select namabarang as 'Nama Barang',stok as 'STOK',hargabeli as 'Harga Beli',hargajual as 'Harga Jual',hargajual-hargabeli as 'Selisih'
from tblBarang
where namabarang like '%Ayam%' OR namabarang like '%Chick%';
/*Nomor 10*/
select MAX(hargajual)as 'harga jual paling tinggi',MIN(hargajual) as 'harga jual paling rendah',MAX(hargabeli) as 'harga beli paling tinggi',
MIN(hargabeli) as 'harga beli paling rendah', AVG(stok) as 'stok rata-rata'
from tblBarang;