Description:
Query:
SELECT
CASE WHEN vendor IS NULL THEN 'Unknown' ELSE vendor END AS vendor,
COUNT(*) AS machines
FROM vending_machine
GROUP BY vendor
ORDER BY COUNT(*) DESC;
Share this link via
Or copy link
YOUR AD GOES HERE
YOUR AD GOES HERE
YOUR AD GOES HERE