CREATE TABLE dept_locations (dnumber NUMBER, dlocation CLOB)
CREATE TABLE department (dname CLOB, dnumber NUMBER, mgr_ssn NUMBER, mgr_start_date CLOB)
CREATE TABLE dependent (essn NUMBER, dependent_name CLOB, sex CLOB, bdate CLOB, relationship CLOB)
CREATE TABLE works_on (essn NUMBER, pno NUMBER, hours NUMBER)
CREATE TABLE employee (fname CLOB, minit CLOB, lname CLOB, ssn NUMBER, bdate CLOB, address CLOB, sex CLOB, salary NUMBER, super_ssn NUMBER, dno NUMBER)
CREATE TABLE project (pname CLOB, pnumber NUMBER, plocation CLOB, dnum NUMBER)

list the first and last names, and the addresses of all employees in the ascending order of their birth date.
SELECT fname, lname, address FROM employee ORDER BY bdate
SELECT "fname", "lname", "address" FROM "employee" ORDER BY "bdate"