如果你想查看录入盒子数量包含50个的用户,可以使用以下查询:
SELECT ua.open_id, COUNT(cb.id) AS box_count FROM user_account ua JOIN cigarette_box cb ON ua.open_id = cb.open_id GROUP BY ua.open_id HAVING box_count >= 50;
要查询有多少用户录入了盒子,你可以使用以下MySQL查询语句:
SELECT COUNT(DISTINCT ua.id) AS user_count FROM user_account ua JOIN cigarette_box cb ONua.open_id = cb.open_id;