Skip to content

Instantly share code, notes, and snippets.

Avatar
👽
alien

Emad Saeed emads3

👽
alien
  • Information technology institute (ITI)
  • Dubai
View GitHub Profile
@emads3
emads3 / console_2.sql
Created Jul 28, 2020
solve median problem in hacker rand with example
View console_2.sql
# 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