Skip to content

Instantly share code, notes, and snippets.

View emads3's full-sized avatar
🎯
Focusing

emad emads3

🎯
Focusing
  • Dubai
View GitHub Profile
@emads3
emads3 / console_2.sql
Created July 28, 2020 05:42
solve median problem in hacker rand with example
# https://www.hackerrank.com/challenges/weather-observation-station-20/problem
# Example on Sakila DB
# select case
# when count(actor_id) % 2 = 0 then (
# select sum(actor_id)
# from (
# select *
# from (
# select actor_id
# from actor a