-- order-by
create table customer(customerID int,customerName varchar(255),country varchar(255));
insert into customer(customerID, customerName,country)values(1,"Alfred","Germany"),(2,"John","Argentina"),(3,"William","America");
select * from customer;
select * from customer
order by country; /* order by for ascending order*/
select * from customer
order by country Desc;/* Desc for descending order using country column(field)*/