Advertisement
Step8rother

Операторы LEFT OUTER JOIN и RIGHT OUTER JOIN, задача 6

Jun 27th, 2023
1,400
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.35 KB | Source Code | 0 0
  1. --Отобразите на экране имена исполнителей, для которых в базе данных не нашлось ни одного музыкального альбома.
  2.  
  3. SELECT art.name
  4. FROM artist AS art
  5. LEFT OUTER JOIN album AS alb ON art.artist_id = alb.artist_id
  6. GROUP BY art.name
  7. HAVING COUNT(alb.artist_id) = 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement