select*from customers order by cust_LeonAgnatio asc;

select*from vendors order by vend_LeonAgnatio desc;

select count(vend_id) from vendors;

select*from orderitems order by order_item desc;

select count(order_item), sum(order_item), avg(order_item), min(order_item), max(order_item) from orderitems;

select*from orderitems where quantity between '5' and '10';

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;