What is the average student GPA?
select avg(stu_gpa) from student
Find students with a GPA less than that?
select * from student where stu_gpa < (select avg(stu_gpa) from student)
What are their first names and GPAs?
select stu_fname, stu_gpa from student where stu_gpa < (select avg(stu_gpa) from student)