| CARVIEW |
Select Language
HTTP/2 200
date: Fri, 10 Oct 2025 23:37:09 GMT
content-type: text/html; charset=UTF-8
server: cloudflare
x-frame-options: DENY
x-content-type-options: nosniff
x-xss-protection: 1;mode=block
vary: accept-encoding
cf-cache-status: DYNAMIC
content-encoding: gzip
set-cookie: _csrf-frontend=733e080afae728d72ee11fef1ffa6a3a63847f82cd6fcb8e6df940bcbcf82ea4a%3A2%3A%7Bi%3A0%3Bs%3A14%3A%22_csrf-frontend%22%3Bi%3A1%3Bs%3A32%3A%22rcOOwpj2RxVUhFEhFLBITf1VgwN75r0J%22%3B%7D; HttpOnly; Path=/
cf-ray: 98c9f1aabfae1712-BLR
WITH -- Параметры для заданного периода времени Parameters AS ( - Pastebin.com
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH
- -- Параметры для заданного периода времени
- Parameters AS (
- SELECT
- '2024-01-01'::DATE AS start_date,
- '2024-12-31'::DATE AS end_date
- ),
- -- CTE для фильтрации заказов за заданный период времени
- FilteredOrders AS (
- SELECT
- o.customer_id,
- o.order_date,
- o.total_amount,
- o.order_id
- FROM
- orders o
- JOIN Parameters p ON o.order_date BETWEEN p.start_date AND p.end_date
- ),
- -- CTE для расчета давности последнего заказа (Recency)
- Recency AS (
- SELECT
- fo.customer_id,
- MIN(fo.order_date) AS last_order_date,
- DATEDIFF(DAY, MIN(fo.order_date), CURRENT_DATE) AS recency,
- RANK() OVER (ORDER BY DATEDIFF(DAY, MIN(fo.order_date), CURRENT_DATE) ASC) AS recency_rank -- Добавляем ранжирование
- FROM
- FilteredOrders fo
- GROUP BY
- fo.customer_id
- ),
- -- CTE для расчета частоты заказов (Frequency)
- Frequency AS (
- SELECT
- fo.customer_id,
- COUNT(fo.order_id) AS frequency,
- RANK() OVER (ORDER BY COUNT(fo.order_id) DESC) AS frequency_rank -- Добавляем ранжирование
- FROM
- FilteredOrders fo
- GROUP BY
- fo.customer_id
- ),
- -- CTE для расчета финансовой ценности (Monetary)
- Monetary AS (
- SELECT
- fo.customer_id,
- SUM(fo.total_amount) AS monetary,
- RANK() OVER (ORDER BY SUM(fo.total_amount) DESC) AS monetary_rank -- Добавляем ранжирование
- FROM
- FilteredOrders fo
- GROUP BY
- fo.customer_id
- )
- -- Финальный запрос для вывода результатов RFM-анализа
- SELECT
- c.customer_name,
- r.recency,
- r.recency_rank, -- Добавляем ранг давности
- f.frequency,
- f.frequency_rank, -- Добавляем ранг частоты
- m.monetary,
- m.monetary_rank, -- Добавляем ранг финансовой ценности
- r.recency_rank + f.frequency_rank + m.monetary_rank AS rfm_total_score -- Добавляем общую оценку RFM
- FROM
- customers c
- JOIN Recency r ON c.customer_id = r.customer_id
- JOIN Frequency f ON c.customer_id = f.customer_id
- JOIN Monetary m ON c.customer_id = m.customer_id
- ORDER BY
- rfm_total_score ASC, -- Сортируем по общей оценке RFM
- r.recency ASC, -- По давности (чем меньше, тем лучше)
- f.frequency DESC, -- По частоте (чем больше, тем лучше)
- m.monetary DESC; -- По финансовой ценности (чем больше, тем лучше)
Advertisement
Add Comment
Please, Sign In to add comment
-
⭐⭐⭐Crypto Accounts⭐⭐
Java | 3 sec ago | 0.10 KB
-
⭐✅ MAKE $2500 IN 15 MIN⭐⭐⭐ O
JavaScript | 7 sec ago | 0.24 KB
-
⭐⭐⭐Swapzone.io Glitch (Working)⭐⭐
Java | 16 sec ago | 0.10 KB
-
⭐✅ Exploit 2500$ in 15 Minutes⭐⭐⭐ 1
JavaScript | 20 sec ago | 0.24 KB
-
Free Crypto Method (NEVER SEEN BEFORE)⭐⭐ D
JavaScript | 33 sec ago | 0.24 KB
-
⭐✅ Swapzone Glitch ✅ Working⭐⭐⭐ G
JavaScript | 43 sec ago | 0.24 KB
-
⭐✅ Swapzone Glitch ✅ Working⭐⭐⭐ 5
JavaScript | 47 sec ago | 0.24 KB
-
✅ Make $2500 in 20 minutes⭐⭐⭐ J
JavaScript | 55 sec ago | 0.24 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
