- SELECT ar.name,
- COUNT(al.album_id) AS alb_count
- FROM artist AS ar
- LEFT OUTER JOIN album AS al ON al.artist_id = ar.artist_id
- GROUP BY ar.name
- HAVING alb_count = 0
Re: Re: Re: task 4
From Emerald Owl, 8 Months ago, written in Plain Text, viewed 292 times.
This paste is a reply to Re: Re: task 4 from Blush Motmot
- view diff
URL http://codebin.org/view/aa55127c
Embed
Download Paste or View Raw
— Expand Paste to full width of browser