SQLTeam.com | Weblogs | Forums

Multi step Query statement


Hi guys,
So I have been tasked to write an SQL Statement that displays all the details of rooms. Display only rooms from 'B1' and 'B4', If the capacity of a room is not between 120 (exclusive) and 160 (exclusive). Capacity must be displayed, not just with the value but with the text 'PEOPLE' appended to it with a space (E.g. '60 PEOPLE'). Use proper aliases for any computational columns.

Im struggling to use all these statements and I keep getting error messages. Any helps or pointers would be great.

So far I've tried:
WHERE BUILDINGNO LIKE '%B1%' AND '%B4$' and I get errors.