text: -- List the following details of each employee: employee number, last name, first name, sex, and salary.
  
  SELECT e.emp_no,e.last_name,e.first_name,e.sex,s.salary
  FROM employees as e
  INNER JOIN salaries as s ON e.emp_no = s.emp_no
  ORDER BY last_name;
  
  -- List first name, last name, and hire date for employees who were hired in 1986.
  
  SELECT first_name,last_name,hire_date
  FROM employees
  WHERE hire_date LIKE '%1986';
  
  -- List the manager of each department with the following information: 
  -- department number, department name, the manager's employee number, last name, first name.
  
  SELECT dept_manager.dept_no,departments.dept_name,employees.emp_no,employees.last_name,employees.first_name
  FROM employees
  INNER JOIN dept_manager ON employees.emp_no = dept_manager.emp_no
  INNER JOIN departments ON dept_manager.dept_no = departments.dept_no;
  
  -- List the department of each employee with the following information: 
  -- employee number, last name, first name, and department name.
  
  SELECT employees.emp_no,employees.last_name,employees.first_name,departments.dept_name
  FROM employees
  INNER JOIN dept_emp ON employees.emp_no = dept_emp.emp_no
  INNER JOIN departments ON dept_emp.dept_no = departments.dept_no;
  
  -- List first name, last name, and sex for employees whose first name is "Hercules" 
  -- and last names begin with "B."
  
  SELECT first_name,last_name,sex
  FROM employees
  WHERE first_name = 'Hercules'
  AND last_name LIKE 'B%';
  
  -- List all employees in the Sales department, including their employee number,
  -- last name, first name, and department name.
  
  SELECT employees.emp_no,employees.last_name,employees.first_name,departments.dept_name
  FROM employees
  INNER JOIN dept_emp ON employees.emp_no = dept_emp.emp_no
  INNER JOIN departments ON dept_emp.dept_no = departments.dept_no
  WHERE departments.dept_name = 'Sales';
  
  -- List all employees in the Sales and Development departments, 
  --including their employee number, last name, first name, and department name.
  
  SELECT employees.emp_no,employees.last_name,employees.first_name,departments.dept_name
  FROM employees
  INNER JOIN dept_emp ON employees.emp_no = dept_emp.emp_no
  INNER JOIN departments ON dept_emp.dept_no = departments.dept_no
  WHERE departments.dept_name = 'Sales'
  OR departments.dept_name = 'Development';
  
  -- In descending order, list the frequency count of employee last names, 
  -- i.e., how many employees share each last name.
  
  SELECT COUNT(last_name) AS count_of_last_name,last_name
  FROM employees
  GROUP BY last_name
  ORDER BY count_of_last_name DESC;
  
  
  