# Como obter o número de soluções por usuário usando o Data Explorer?

**URL:** <https://meta.discourse.org/t/how-to-get-number-of-solutions-per-users-using-data-explorer/146253>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [Março 31, 2020, 9:28am UTC](https://meta.discourse.org/t/how-to-get-number-of-solutions-per-users-using-data-explorer/146253 "2020-03-31T09:28:43Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![BenLeong](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/benleong/32/60951_2.png) [@BenLeong](https://meta.discourse.org/u/BenLeong)\
**Post date:** [Maio 15, 2020, 2:15am UTC](https://meta.discourse.org/t/how-to-get-number-of-solutions-per-users-using-data-explorer/146253/10 "2020-05-15T02:15:54Z")

</div>

Como complemento à consulta de Simon acima, usamos esta versão para visualizar o número de soluções por usuário em um intervalo de datas específico (usando o formato de data `aaaa-mm-dd`):

```sql
--[params]
-- date :start_date
-- date :end_date

SELECT
user_id,
COUNT(1) AS solved_count
FROM user_actions
WHERE created_at::date BETWEEN :start_date AND :end_date
AND action_type = 15
GROUP BY user_id
ORDER BY solved_count DESC

```

É útil poder ver como isso muda de mês para mês.

---

_[View the full topic](https://meta.discourse.org/t/how-to-get-number-of-solutions-per-users-using-data-explorer/146253)._