What is the title, phone and hire date of Nancy Edwards?
select title, phone, hire_date from employees where first_name = "Nancy" and last_name = "Edwards"
what is the total number of employees?
select count ( * ) from employees
yes that is the general manager?
select first_name from employees where title = "General Manager"