TIL - 250126

URL : https://datalemur.com/questions/sql-histogram-tweets

WITH A as(
  SELECT 
    COUNT(user_id) tweet_bucket
  FROM tweets
  WHERE EXTRACT(YEAR FROM tweet_date) = 2022
  GROUP BY user_id
)
SELECT
  tweet_bucket
  ,COUNT(tweet_bucket) users_num
FROM a 
GROUP BY tweet_bucket
;

URL : https://datalemur.com/questions/matching-skills

SELECT candidate_id
FROM candidates
WHERE candidate_id in (
  SELECT candidate_id
  FROM candidates
  WHERE candidate_id in (
    SELECT candidate_id
    FROM candidates
    WHERE skill = 'Python'
  )
  AND skill = 'Tableau'
)
AND skill = 'PostgreSQL'
;