opteryx
opteryx copied to clipboard
✨ support group by aliases
trafficstars
SELECT EXTRACT(YEAR FROM hire_date) AS hire_year, COUNT(*)
FROM employees
GROUP BY hire_year;