SQL Examples: in, case when then, inline view, over(partition by)

select department_id, employee_id, first_name, last_name,

case

when hire_date = first_hire and hire_date = last_hire

then 'Shortest and Longest Serving'

when hire_date = first_hire then 'Longest Serving'

when hire_date = last_hire then 'Shortest Serving'

end Department_Tenure

from (

select department_id, employee_id, first_name, last_name, hire_date,

max(hire_date) over(partition by department_id) first_hire,

min(hire_date) over(partition by department_id) last_hire

from hr.employees

) Hire_Dates

where hire_date in (first_hire, last_hire)

order by department_id, department_tenure;

References:
G Allen, B Bryla, D Kuhn, and C Allen, "Oracle SQL Recipes A Problem-Solution Approach", 1st ed, Apress, 2009.

Tasks of instructors (lecturers)

Tasks of instructors (lecturers)

Figure: Tasks of instructors (lecturers)

Types of image noise

1. Additive Gaussian noise
2. Blurring
3. Salt and pepper noise
4. Low contrast
5. Multiplicative Gaussian noise
6. Structure noise
7. Random noise
8.  Shot noise
9. Quantization noise
10. Banding noise
11. Shadow noise
12. Burst noise
13. White noise
14. Flicker noise
15. Additive white Gaussian noise
16. Grey noise
17. Pink noise
18. Thermal noise
19. Coherent noise (value noise, gradient noise, worley noise)

Common English speaking and writing mistakes Day 01

I. Common mistakes set 1

II. How to place English adjectives in a correct order

Structure of a cover letter

I. Structure of a cover letter

Which brands of car that cost most to maintain

I. Which brands of car that cost most to maintain

What happens in an Internet minute in 2016

I. What happens in an Internet minute in 2016