DefconOne

Расчёт относительных значений. Конверсия

Sep 14th, 2022
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT ROUND(COUNT(DISTINCT o.user_id) * 100.0 / COUNT(DISTINCT u.user_id), 1) conv
  2. FROM tools_shop.users u
  3. LEFT JOIN tools_shop.orders o ON u.user_id = o.user_id
Advertisement
Add Comment
Please, Sign In to add comment