# 검색 로그 - 특정 날짜 범위의 전체 목록을 가져오는 방법?

**URL:** https://meta.discourse.org/t/search-logs-how-to-get-a-complete-list-for-a-given-date-range/272825
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [7월 25, 2023, 10:12오후 UTC](https://meta.discourse.org/t/search-logs-how-to-get-a-complete-list-for-a-given-date-range/272825 "2023-07-25T22:12:15Z")
**Posts on this page:** 1
**Showing post:** 7

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [7월 29, 2023, 12:12오후 UTC](https://meta.discourse.org/t/search-logs-how-to-get-a-complete-list-for-a-given-date-range/272825/7 "2023-07-29T12:12:04Z")

</div>

이런 식으로 수정하면 더 나을 것 같습니다:

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

WITH results AS (

SELECT LOWER(term) AS term,
       COUNT(*) AS searches,
       SUM(CASE WHEN search_result_id IS NOT NULL THEN 1 ELSE 0 END) AS click_through
FROM search_logs
WHERE created_at BETWEEN :start_date AND :end_date
GROUP BY term

)

SELECT term AS "Search Term",
       searches AS "Searches",
       click_through AS "Clicks-Through",
       CEIL ((click_through/searches::float) * 100) || '%' AS "CTR"
FROM results
ORDER BY searches DESC

```

도움이 되었기를 바랍니다. 조정하고 싶은 부분이 있으면 알려주세요. 🙂

---

_[View the full topic](https://meta.discourse.org/t/search-logs-how-to-get-a-complete-list-for-a-given-date-range/272825)._