Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Отобразите на экране имена исполнителей, для которых в базе данных не нашлось ни одного музыкального альбома.
- SELECT art.name
- FROM artist AS art
- LEFT OUTER JOIN album AS alb ON art.artist_id = alb.artist_id
- GROUP BY art.name
- HAVING COUNT(alb.artist_id) = 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement