Query editor
withbets_stats as(SELECTcount(distinct bet_id) as bets,count(distinct bettor) as unique_users,sum(usd_amount-usd_payoutAmount) as prediction_amount,sum(usd_amount) as bet_amount,sum(usd_GGR) as total_profit,sum(usd_GGR) / sum(usd_amount) * 100 as betting_take_rateFROM dune.azuro.result_ordinars_combos_resolved),six_mo AS(SELECTavg(usd_amount) as avg_6mo_bet_amountFROM dune.azuro.result_ordinars_combos_resolvedWHERE bet_time > current_date - interval '6' month),stats_per_user AS(SELECTsum(usd_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 dune.azuro.result_ordinars_combos_resolved),combos_bets AS(SELECTcount(distinct bet_id) as combo_bets,sum(usd_amount-usd_payoutAmount) as combo_bets_amount,sum(usd_GGR) as combo_bets_GGRFROM dune.azuro.result_ordinars_combos_resolvedWHERE bet_type = 'combo'),ordinar_bets AS(SELECTcount(distinct bet_id) as ordinar_bets,sum(usd_amount-usd_payoutAmount) as ordinar_bets_amount,sum(usd_GGR) as ordinar_bets_GGRFROM dune.azuro.result_ordinars_combos_resolvedWHERE bet_type = 'ordinar' AND NOT is_live),live_bets AS(SELECTcount(distinct bet_id) as live_bets,sum(usd_amount-usd_payoutAmount) as live_bets_amount,sum(usd_GGR) as live_bets_GGRFROM dune.azuro.result_ordinars_combos_resolvedWHERE 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