Skip to content

Instantly share code, notes, and snippets.

SELECT keyword, count(*) c
FROM search_logs
GROUP BY keyword
ORDER BY c DESC
SELECT *
FROM search_logs
WHERE keyword = ‘rockset’
AND locale = ‘en’
SELECT * FROM search_logs WHERE keyword = 'rockset' AND locale = 'en'