What is the first name and GPA of every student that has a GPA lower than average?
SELECT stu_fname ,  stu_gpa FROM student WHERE stu_gpa  <  (SELECT avg(stu_gpa) FROM student)
first name refers to stu_fname; GPA refers to stu_gpa; GPA lower than average refers to stu_gpa < AVG(stu_gpa);