title: mysql min and max values in subquery
body: <p>thanks in advance for the help. I'm a noob with sql and this is probably a pretty basic question, but I have been working on it for hours and can't seem to figure out what I'm doing wrong. </p>
  
  <p>Here is the question posed: 
  Using aggregate functions, display the employee name (first and last name concatenated) in a field named Employee Name and the hire date of the employee who has been employed the longest and the employee who was hired last.</p>
  
  <p>I have tried to code this different ways to no avail. I always get one result instead of the two I know I should get. (I know I should get two results because I'm working with a very small table and can calculate the answer by looking at it - easy to make sure I'm getting the right results that way.) </p>
  
  <p>Here is one way I coded it: 
  <a href="https://i.stack.imgur.com/fwtWf.png" rel="nofollow noreferrer">subquery</a></p>
  
  <p>Here, I used a sub query for the min and max. I used 'and' in between because I want both results. I only get one. If I use 'or', I get too many results
  I have also tried it this way: </p>
  
  <p><a href="https://i.stack.imgur.com/EZZ4U.png" rel="nofollow noreferrer">min/max in select statement</a>
  Here, I still get only one employee name back, but now I get both dates. The dates are the correct dates, but I need the output to look like the first query output. </p>
  
  <p>Any help anyone can provide would be greatly appreciated!</p>