Quis BDT

create database rozie_anggriono_2010240346

use rozie_anggriono_2010240346

create table TblProduk
(no integer identity (1,1) primary key,
    Kode varchar(20),
    Merk varchar(100) not null,
    Satuan varchar(50),
    Harga_satuan integer,
    Jumlah_stok integer,
)

insert into TblProduk values('BM001', 'Minyak Bimoli 1 KG', 'Botol',4500,2432)
insert into TblProduk values('BM002', 'Minyak Bimoli 2 KG', 'Botol',1000,2112)
insert into TblProduk values('CR001', 'Shampo Clear', 'Botol',8000,1244)
insert into TblProduk values('LX001', 'Sabun Lux', 'Buah',1000,1298)
insert into TblProduk values('pp001', 'Pepsodent Kecil', 'Kotak',3400,5432)
insert into TblProduk values('pp002', 'Pepsodent Besar', 'Kotak',5000,6432)
insert into TblProduk values('PS001', 'Pocari Sweat', 'Kaleng',5000,2432)
insert into TblProduk values('SM001', 'Sampoerna Mild 16 Batang', 'Bungkus',9800,9432)
insert into TblProduk values('SM002', 'Sampoerna Mild 12 Batang', 'Bungkus',6700,9432)
insert into TblProduk values('SM003', 'Sampoerna Hijau', 'Bungkus',6800,7232)
insert into TblProduk values('SN001', 'Shampo Sunsilk', 'Botol',2000,5633)
insert into TblProduk values('YL001', 'Yakult', 'Kaleng',1200,5242)

select * from TblProduk

exec sp_rename 'TblProduk', 'barang'

select * from barang

update barang
set satuan = 'botol' where satuan = 'kaleng'

select top 73 percent * from barang

select *, Harga_satuan * Jumlah_stok as "Total Harga" from Barang

select Merk, Harga_satuan from Barang where Satuan = 'Botol' and Harga_satuan > 2000

SEMOGA BERMANFAAT

---