Miscellany
public text v1 · immutableSELECT
marketdaily.marketdaily_id
, marketdaily.date
, marketdaily.closing_price
FROM
marketdaily INNER JOIN (
SELECT
marketdaily_id
FROM
marketdaily
WHERE
symbol = 'ARBK'
AND
DAY(date) <= 3
ORDER BY
date DESC
) sub ON marketdaily.marketdaily_id = sub.marketdaily_id
GROUP BY
YEAR(marketdaily.date) DESC, MONTH(marketdaily.date) DESC;