Ex4.sql

SELECT au_lname, au_fname
FROM authors
WHERE au_id =
(SELECT title_id, 
FROM titles 
WHERE 
(SELECT title_id, 
FROM titles, 
WHERE type='Popular_comp'));