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'
;