Query editor
withbets_stats as(SELECTcount(distinct bet_id) as bets,count(distinct bettor) as unique_users,sum(amount-payoutAmount) as bet_amount,sum(GGR) as total_profit,sum(GGR) / sum(amount-payoutAmount) * 100 as betting_take_rateFROM query_2832316),six_mo AS(SELECTavg(amount) as avg_6mo_bet_amountFROM query_2832316WHERE bet_time > current_date - interval '6' month),stats_per_user AS(SELECTsum(amount) / count(distinct bettor) as bet_amount_per_user,cast(count(distinct bet_id) as double) / cast(count(distinct bettor) as double) as bets_count_per_userFROM query_2832316),combos_bets AS(SELECTcount(distinct bet_id) as combo_bets,sum(amount-payoutAmount) as combo_bets_amount,sum(GGR) as combo_bets_GGRFROM query_2832316WHERE bet_type = 'combo'),ordinar_bets AS(SELECTcount(distinct bet_id) as ordinar_bets,sum(amount-payoutAmount) as ordinar_bets_amount,sum(GGR) as ordinar_bets_GGRFROM query_2832316WHERE bet_type = 'ordinar' AND NOT is_live),live_bets AS(SELECTcount(distinct bet_id) as live_bets,sum(amount-payoutAmount) as live_bets_amount,sum(GGR) as live_bets_GGRFROM query_2832316WHERE bet_type = 'ordinar' AND is_live)SELECT*FROM bets_statsCROSS JOIN six_moCROSS JOIN stats_per_userCROSS JOIN combos_betsCROSS JOIN ordinar_betsCROSS JOIN live_bets