Miscellany

SELECT	marketdaily.marketdaily_id	, marketdaily.date	, marketdaily.closing_priceFROM	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_idGROUP BY	YEAR(marketdaily.date) DESC, MONTH(marketdaily.date) DESC;