Database Reference
In-Depth Information
Figure 6.51
Query information about building.
Figure 6.52
Use LIKE operator with wildcard.
4. Example 3: With a subquery, select the name(s) of the faculty member(s) who advise(s)
the student whose irst name is Liz. Enter the below query.
SELECT FirstName, LastName
FROM FACULTY
WHERE FacultyID IN (SELECT FacultyID
FROM STUDENT
WHERE FirstName
=
'Liz')
