How many of each category of bikes do we have in our "Baldwin Bikes" store sort by lowest numbers first SELECT category_name, COUNT (category_name ) AS "instock" FROM store s JOIN stock st ON s.store id = st.store 10 JOIN product ON product .product id = st . product id JOIN category ON category . category id = product . category_id WHERE store name LIKE "BY" GROUP BY category name ORDER BY instock; - - Error Code: 1055. Expression #3 of SELECT list is not in GROUP BY clause and contains monaggregated column bike. st . quantity " which is not functionally dependent on columns in GROUP BY clause; this is incompatible with Sol_modesonly_full_group_by