what is the budget for chandler?
select budget from department where building = "Chandler"
how many departments are in table?
select count ( * ) from department
how many buildings are available?
select count ( distinct building ) from department
which department is managed by taylor?
select dept_name from department where building = "Taylor"
how much budget is taking biology department?
select budget from department where dept_name = "Biology"