Re: Re: Re: task 4

From Emerald Owl, 2 Months ago, written in Plain Text, viewed 128 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

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

Replies to Re: Re: Re: task 4

Title	Name	Language	When
Re: Re: Re: Re: task 4	Abrupt Leech	text	2 Months ago.

Reply to "Re: Re: Re: task 4"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?