TIL - 250125

URL : https://datalemur.com/questions/tesla-unfinished-parts

SELECT
  DISTINCT card_name
  ,FIRST_VALUE(issued_amount) OVER(PARTITION BY card_name ORDER BY issue_year, issue_month)
FROM monthly_cards_issued
ORDER BY 2 DESC
;