drop database if exists dbdbAnggur;
create database dbdbAnggur;
  use dbdbAnggur;

  create table tblAnggur(
    Nama_Anggur VARCHAR(100),
    Negara_Asal VARCHAR(100),
    Waktu_Produksi TIMESTAMP,
    Waktu_Kadaluarsa TIMESTAMP,
    Style VARCHAR(30),
    Harga DOUBLE
  );

  insert into tblAnggur values
    ('Black Stump Durif','Australia','2007-01-20 10:10:10','2010-10-20 10:10:10','Black Wine','75'),
    ('Awesome Aussies','Australia','2007-01-15 06:15:10','2009-11-07 09:20:10','Beer','70'),
    ('French Midi Champions Collection','Prancis','2006-03-17 07:18:20','2009-11-10 09:10:10','Rose Wine','72'),
    ('Bordeaux 2005 Showcase','Prancis','2005-04-18 08:17:12','2008-07-10 09:10:10','Rose Wine','74'),
    ('Brightwater Sauvignon Blanc 2007','New Zealand','2007-01-15 06:15:10','2013-10-20 08:20:10','White','70'),
    ('Palacio de Monsalud 2001','Spanyol','2001-01-15 06:15:10','2014-10-20 08:20:10','Red Wine','63'),
    ('Baron de Turis 2007','Spanyol','2007-04-15 07:25:13','2010-10-20 09:10:30','Champagne & Sparkling','92'),
    ('Reserva Showcase','Spanyol','2002-07-14 08:25:18','2015-10-20 10:40:15','Red Wine','56'),
    ('Il Papavero NV','Italy','2003-07-18 08:34:17','2008-10-20 11:34:25','Beer','57'),
    ('Italy Glorious 2007 Collection','Italy','2007-05-25 10:37:18','2008-10-20 09:18:12','White','82'),
    ('Vespaiolo Frizzante NVI','taly','2005-01-30 09:23:19','2010-10-20 11:42:15','Beer','56'),
    ('Chile 2007 + 3 Cabernet','Chile','2007-09-18 10:45:50','2011-10-20 06:47:13','Champagne & Sparkling','78'),
    ('Las Casas de Vaqueria Merlot Half Bottle 2006','Chile','2006-02-17 11:15:27','2014-10-20 11:10:10','Beer','69'),
    ('Las Casas de Vaqueria Sauvignon Blanc 2007','Chile','2007-01-15 07:15:10','2012-10-20 08:40:10','White','87');

select * from tblAnggur
EXCEPT
SELECT * from tblAnggur
WHERE Negara_Asal='Spanyol';

SELECT * FROM tblAnggur
EXCEPT
SELECT * from tblAnggur
WHERE Waktu_Kadaluarsa<'2010-12-12';

select * from tblAnggur
EXCEPT
SELECT * from tblAnggur
WHERE Harga BETWEEN 80 AND 90;

select * from tblAnggur
EXCEPT
SELECT * from tblAnggur
WHERE Style='Beer';

UPDATE tblAnggur
SET Harga=Harga+15
WHERE Nama_Anggur LIKE 'B%' OR Nama_Anggur LIKE 'P%';
select * from tblAnggur;

UPDATE tblAnggur
SET Harga=Harga-10
WHERE Waktu_Produksi LIKE '2002' OR '2003';
select * from tblAnggur;

UPDATE tblAnggur
SET Style='Wine'
WHERE Negara_Asal LIKE 'Prancis' OR 'Chile' AND Waktu_Produksi='2006';
select * from tblAnggur;