queries(query_id, product_name, user_id, queried_at)

For September 2026, return each product's number of distinct querying users and its total query count, keeping only products with at least 100 queries.

Return product_name, unique_users and query_count, ordered by product_name.

The same user querying repeatedly counts once toward unique_users and many times toward query_count.

Tables

queries

query_id  product_name  user_id  queried_at
--------  ------------  -------  ----------
1         alpha         2        2026-09-10
2         alpha         3        2026-09-10
3         alpha         1        2026-09-10
4         alpha         2        2026-09-10
5         alpha         3        2026-09-10
6         alpha         1        2026-09-10
7         alpha         2        2026-09-10
8         alpha         3        2026-09-10
... 461 more row(s)

Expected result

product_name  unique_users  query_count
------------  ------------  -----------
alpha         3             120
beta          5             100