# アクセス頻度の例

アクセス頻度の分布。これは、ユーザーエンゲージメントの分布を確認するのに役立ちます。

* [HiveとTrinoのアクセス頻度クエリ例](/ja/products/customer-data-platform/data-workbench/queries/examples/access-frequency-example#access-frequency-query-example-for-hive-and-presto)
* [サンプル入力](/ja/products/customer-data-platform/data-workbench/queries/examples/access-frequency-example#sample-input)
* [サンプル出力](/ja/products/customer-data-platform/data-workbench/queries/examples/access-frequency-example#sample-output)


## HiveとTrinoのアクセス頻度クエリ例


```sql
SELECT
  T.cnt,
  COUNT(1) AS frequency
FROM (
    SELECT
      user_id,
      COUNT(1) AS cnt
    FROM
      access
    GROUP BY
      user_id
  ) T
GROUP BY
  T.cnt
ORDER BY
  frequency
```

## サンプル入力

| **time** | **user_id** |
|  --- | --- |
| 1416435585 | 2 |
| 1416435586 | 3 |
| 1416435587 | 5 |
| 1416435588 | 1 |
| ... | ... |


## サンプル出力

| **cnt** | **frequency** |
|  --- | --- |
| 1 | 621 |
| 2 | 121 |
| 3 | 71 |
| 4 | 61 |
| 5 | 41 |
| 6 | 31 |
| 7 | 11 |
| 8 | 3 |
| 9 | 1 |