I do not understand the following SQL code:
SELECT price, COUNT (*)
GROUP BY price;
This code returns the price and the number of apps of that price. How does the code know to count the number of rows with the same price, as COUNT(*) returns the number of rows and there is no WHERE condition?