SQLite - Count and More Than

Question

Cannot build correctly

Integer indicatedAmount = 2; String sql = "SELECT customer_id, count(id) as count_of_orders from orders group by customer_id";

You need something like:

 String sql = "SELECT customer_id, count(id) AS count_of_orders FROM orders WHERE count_of_orders > 2 GROUP BY customer_id";

Sergey Gornostaev Sergey Gornostaev 53.3k 6 28 66 · Accepted Answer · 2017-10-26T16:27:58

 select customer_id, count(id) as count_of_orders from orders group by customer_id having count(id) > 2;

1 answer 1