Yes
select fname, lname from student
Show me the Age list of all students
select age from student
Show me the first and last name of students whose age is younger than the average age
select fname, lname from student where age < ( select avg ( age ) from student )