How many physicians are there in total?
select count ( * ) from physician
What are their names?
select name from physician
Which of their position titles contain the word senior in it?
select position from physician where position like '%senior%'
What is the name of that physician who has the Senior Attending Physician title?
select name from physician where position like '%senior%'