This article provides an example to display customers which are from satellite area of ahmedabad, nadiyad cities.
select cname from cust where city in('Ahmedabad','Nadiyad') and area like'Satellite';