Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

This should work, right? Just a bit more unnecessary text.

SELECT year, sales, income FROM ( SELECT year, COUNT(*) sales, SUM(price) income FROM sales ) AS innerquery WHERE sales > 10 AND income < 1000;



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: