select*from vendors where vend_country like 'USA';

select*from vendors where vend_LeonAgnatio like '%p%';

select*from product where prod_id like '%p%';

select prod_name as 'Nama Produk', prod_price as 'Harga' from product;

select current_date 'Tanggal Praktikum';

select current_time as 'Jam Sekarang';

select time '08:00:00' - time '08:46:38';

select ((year(curdate())-year('2000-07-05')) - (right(curdate(),5) < right('2000-07-05',5))) as Umur;