How many faculty members are in building Barton?
select count ( * ) from faculty where building = "Barton"
Please list the faculty members in building Barton.
select * from faculty where building = "Barton"
Can you please get just their last names?
select lname from faculty where building = "Barton"
Of the faculty members in building Barton, how many are in each rank?
select rank, count ( * ) from faculty where building = "Barton" group by rank
Can you please list the last names of the faculty in Barton one more time, in alphabetical order?
select lname from faculty where building = "Barton" order by lname