Who has same qualification as Stanley Garner?

Question

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.)

Answer 1

```
SQL> SELECT Lname, Fname, QualId
2 FROM employee
3 WHERE QualId =
4 (SELECT QualId
5 FROM employee
6 WHERE UPPER(Lname) = 'GARNER'
7 AND UPPER(Fname) = 'STANLEY');

LNAME FNAME QUALID
--------------- --------------- ----------
Garner Stanley 5
```