show the first and last name of all students.
select fname, lname from student
what are their ages?
select fname, lname, age from student
what is the average age?
select avg(age) from student
list the students whose age is younger than that. List their first and last names.
select fname, lname from student where age < (select avg(age) from student)