Show the information for all faculty.
select * from faculty
Only show the information for the faculty named Jerry Prince.
select * from faculty where fname = "Jerry" and lname = "Prince"
Show the phone, room, and building for this person.
select phone, room, building from faculty where fname = "Jerry" and lname = "Prince"