- 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 COUNT(al.album_id) is Null
Title | Name | Language | When |
---|---|---|---|
Re: Re: Re: Re: Re: task 4 | Edgy Goose | text | 2 Months ago. |