sql - 如何显示至少有 10 次销售的商店

Question

我有一个包含商店(id、商店名称、地址)的表和另一个销售表(shopsid、产品、价格、数量)。我如何显示至少有 10 个销售额的商店，

我知道这行代码很糟糕 where count(shopsid) >= 10

select id, shopname from shops
join sales on sales.shopsid = shops.id
where count(shopsid) >= 10
order by id;

我想看到的是至少有 10 次销售的商店的 ID。而且我不知道如何使该计数起作用或正确实现。

Answer 1

select id, shopname from shops
join sales on sales.shopsid = shops.id
GROUP BY id, shopname
HAVING count(shopsid) >= 10
order by id;