Which employees are working in the company longer than Larry Houston?

Use the N2 Corporation database tables to design the following subqueries. (Use the spooling method to capture all queries and results in the CHAP8SP1.LST file.)

```
SQL> SELECT Lname, Fname, HireDate
2 FROM employee
3 WHERE HireDate <
4 (SELECT HireDate
5 FROM employee
6 WHERE UPPER(Lname) = 'HOUSTON'
7 AND UPPER(Fname) = 'LARRY');

LNAME FNAME HIREDATE
--------------- --------------- ---------
Smith John 15-APR-60
```