title: CREATE VIEW with concatenated fields
body: <p>I have a table with Last Names, First Names, Hours and GPA's. </p>
  
  <p>How do I create a view that displays a concatenated first name and last name, the StudentID and the GPA of the students who have passed at least 90 hours.</p>
  
  <p>The concatenated names should be separated with one space. 
  The three column headings should be FullName, StudentID and GPA. 
  The rows should be sorted by last names, then first names.</p>
  
  <p>Please help. I am lost as to how to approach this.</p>