Re: task 4

From Ivory Tortoise, 6 Months ago, written in Plain Text, viewed 206 times. This paste is a reply to task 4 from Ilya - view diff

URL http://codebin.org/view/ff93bc71 Embed

Download Paste or View Raw

SELECT s.last_name AS employee_last_name,
       ss.reports_to AS manager_last_name
FROM staff AS s
LEFT JOIN staff AS ss ON s.employee_id=ss.reports_to
GROUP BY 1, 2
 
SELECT DISTINCT s.last_name AS employee_last_name,
       ss.reports_to AS manager_last_name
FROM staff AS s
LEFT JOIN staff AS ss ON s.employee_id=ss.reports_to

Replies to Re: task 4

Title	Name	Language	When
Re: Re: task 4	Blush Motmot	text	6 Months ago.
Re: Re: task 4	Mammoth Marten	text	6 Months ago.

Reply to "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?