2 ms·
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 inn
by Linosaurus 4y ago
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;