Yes please
select fname, lname from student where city_code = 'HKG'
Who are not living in that city with code HKG?
select fname, lname from student where city_code ! = 'HKG'
What is the average age of those who don't live in that city?
select avg ( age ) from student where city_code ! = 'HKG'