CREATE TABLE student (fname VARCHAR2, lname VARCHAR2, age NUMBER)

Find 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)
SELECT "fname", "lname" FROM "student" WHERE "age" < (SELECT AVG("age") FROM "student")