I am making these two queries to download the colors and the quantity of each color in the bike
table:
SELECT DISTINCT color FROM bike ORDER BY color ASC
SELECT COUNT(color) FROM bike GROUP BY color ORDER BY color ASC
How do I make the second query, the counts also come with the associated color name, in an array only?