create table addresslistn (aname name, address name, city name, telephone name, postalcode name, numfield integer);
insert into addresslistn values ('Aardvark', '101 Street', 'Sometown', '999-000', 'H0H 0H0', 1);
insert into addresslistn values ('Beebop', '901 Street', 'Sometown', '888-000', 'T0T 0H0', 2);
insert into addresslistn values ('Xerox', '801 Street', 'Sometown', '777-000', 'K0H 0H0', 3);
insert into addresslistn values ('Middling', '1101 Street', 'Sometown', '333-000', 'R0R 0H0', 4);
insert into addresslistn values ('Lost', '1 Avenue', 'Sometown', '456-000', 'X0X 0H0', 5);
insert into addresslistn values ('Timeout', '202 Street', 'Sometown', '789-000', 'T0H 0H0' ,5);
insert into addresslistn values ('What Where Who', '555 Street', 'Where', '911-000', 'T0H 0H0', 6);
insert into addresslistn values ('Catalog', '989 Street', 'LittleBurg', '911-001', 'T0H 0H0', 7);
insert into addresslistn values ('Premium', '21 Street', 'Bigcity', '222-4444', 'W0W 0H0', 8);
insert into addresslistn values ('ToastMaster', '13 Street', 'Waytown', '444-000', 'W0R 0H0', 9);
insert into addresslistn values ('Dumbthing', '888 Street', 'Thistown', '555-000', 'W0T 0H0', 9);
select city from addresslistn order by city desc;
select city from addresslistn order by city asc;
select city, numfield from addresslistn order by numfield asc;
select city, numfield from addresslistn order by numfield desc;
select distinct city from addresslistn;
