Praktek SQL
create database "201553031" use "201553031" create table barang (kdbrg varchar (10) primary key, nmbrg varchar (50), jnsbrg varchar (20), harga int, jumlah int, ); select * from barang insert into barang values ('001', 'Indomie', 'mie instan', 2000, 50) insert into barang values ('002', 'Sunsilk', 'Shampoo', 14000, 100) insert into barang values ('003', 'Pepsodent', 'pasta gigi', 7000, 75) insert into barang values ('004', 'LA Light', 'rokok', 18000, 200) insert into barang values ('005', 'SGM 3', 'Susu Bayi', 75000, 150) select * from barang 1. Tampilkan yang nama barangnya indomie select * from barang where nmbrg='indomie' 2. Tampilkan yang jenisnya shampoo select * from barang where jnsbrg='shampoo' 3. Tampilkan yang harganya 18000 select * from bar