Untitled

From Crimson Gibbon, 5 Months ago, written in SQL, viewed 59 times.

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

Download Paste or View Raw

SELECT last_name,
    first_name,
    title,
      CASE 
          WHEN title LIKE '%IT%' THEN 'разработка'
          WHEN (title LIKE '%Manager%') 
              AND (title NOT LIKE '%IT%')  
              THEN 'отдел продаж'
          WHEN title LIKE '%Support%' THEN 'поддержка'
      END
FROM staff;

Reply to "Untitled"

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?