Analyst agent supervisor console

SQL attempts

SELECT COUNT(*) AS rejected_withdrawals_count FROM withdrawals WHERE review_outcome = 'rejected' AND CAST(ts AS DATE) BETWEEN '2026-08-01' AND '2026-08-31'

Executed SQL (sha df342c21957ed721)

SELECT
  COUNT(*) AS rejected_withdrawals_count
FROM withdrawals
WHERE
  review_outcome = 'rejected'
  AND CAST(ts AS DATE) BETWEEN '2026-08-01' AND '2026-08-31'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT day, ggr_eur FROM rpt_daily_ggr WHERE day BETWEEN CURRENT_DATE - INTERVAL '90 days' AND CURRENT_DATE ORDER BY ggr_eur DESC LIMIT 5

Executed SQL (sha 65766b4a6501c9aa)

SELECT
  day,
  ggr_eur
FROM rpt_daily_ggr
WHERE
  day BETWEEN CURRENT_DATE - INTERVAL '90' DAYS AND CURRENT_DATE
ORDER BY
  ggr_eur DESC
LIMIT 5

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT SUM(stake_eur) AS total_stake_eur FROM bets WHERE CAST(ts AS DATE) BETWEEN '2026-07-21' AND '2026-08-20'

Executed SQL (sha 22125a9f73f4b6d6)

SELECT
  SUM(stake_eur) AS total_stake_eur
FROM bets
WHERE
  CAST(ts AS DATE) BETWEEN '2026-07-21' AND '2026-08-20'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

Sent to the user

Grade this turn

Inbound screening

blocked by pattern: you are now\b

Sent to the user

Grade this turn

Inbound screening

blocked by pattern: ignore (all |any |your )?(previous|prior|above|earlier) (instructions|prompts|rules)

Sent to the user

Grade this turn

SQL attempts

Sent to the user

Grade this turn

SQL attempts

Sent to the user

Grade this turn

SQL attempts

Sent to the user

Grade this turn

SQL attempts

Sent to the user

Grade this turn

SQL attempts

Sent to the user

Grade this turn

SQL attempts

Sent to the user

Grade this turn

SQL attempts

Sent to the user

Grade this turn

SQL attempts

Sent to the user

Grade this turn

SQL attempts

SELECT MAX(amount_eur) AS biggest_withdrawal FROM withdrawals WHERE status = 'settled' AND CAST(ts AS DATE) BETWEEN '2026-08-01' AND '2026-08-31'

Executed SQL (sha 05de8594fd9e2b41)

SELECT
  MAX(amount_eur) AS biggest_withdrawal
FROM withdrawals
WHERE
  status = 'settled' AND CAST(ts AS DATE) BETWEEN '2026-08-01' AND '2026-08-31'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT COUNT(DISTINCT player_id) AS distinct_players_deposited FROM deposits WHERE CAST(ts AS DATE) BETWEEN '2026-07-01' AND '2026-07-31' AND status = 'settled'

Executed SQL (sha f508905dc8e220a6)

SELECT
  COUNT(DISTINCT player_id) AS distinct_players_deposited
FROM deposits
WHERE
  CAST(ts AS DATE) BETWEEN '2026-07-01' AND '2026-07-31' AND status = 'settled'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT provider, SUM(payout_eur) / NULLIF(SUM(stake_eur), 0) AS payout_ratio FROM bets GROUP BY provider ORDER BY payout_ratio DESC LIMIT 1

Executed SQL (sha 9d43bfa576485af5)

SELECT
  provider,
  SUM(payout_eur) / NULLIF(SUM(stake_eur), 0) AS payout_ratio
FROM bets
GROUP BY
  provider
ORDER BY
  payout_ratio DESC
LIMIT 1

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT day, SUM(deposits_eur) AS total_deposits, SUM(withdrawals_eur) AS total_withdrawals FROM rpt_daily_cashflow WHERE day BETWEEN DATE '2026-08-11' AND DATE '2026-08-20' GROUP BY day ORDER BY day

Executed SQL (sha 6b6f1588d27c1448)

SELECT
  day,
  SUM(deposits_eur) AS total_deposits,
  SUM(withdrawals_eur) AS total_withdrawals
FROM rpt_daily_cashflow
WHERE
  day BETWEEN CAST('2026-08-11' AS DATE) AND CAST('2026-08-20' AS DATE)
GROUP BY
  day
ORDER BY
  day
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT AVG(bets_count) AS avg_bets_per_active_player_per_day FROM (SELECT CAST(ts AS DATE) AS day, COUNT(bet_id) AS bets_count, COUNT(DISTINCT player_id) AS active_players FROM bets WHERE CAST(ts AS DATE) BETWEEN '2026-08-01' AND '2026-08-31' GROUP BY day) AS daily_bets;

Executed SQL (sha ac9c2785a836f1c1)

SELECT
  AVG(bets_count) AS avg_bets_per_active_player_per_day
FROM (
  SELECT
    CAST(ts AS DATE) AS day,
    COUNT(bet_id) AS bets_count,
    COUNT(DISTINCT player_id) AS active_players
  FROM bets
  WHERE
    CAST(ts AS DATE) BETWEEN '2026-08-01' AND '2026-08-31'
  GROUP BY
    day
) AS daily_bets
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT SUM(CASE WHEN CAST(day AS DATE) BETWEEN '2026-08-01' AND '2026-08-15' THEN ggr_eur ELSE 0 END) AS ggr_first_half, SUM(CASE WHEN CAST(day AS DATE) BETWEEN '2026-08-16' AND '2026-08-31' THEN ggr_eur ELSE 0 END) AS ggr_second_half FROM rpt_daily_ggr WHERE CAST(day AS DATE) BETWEEN '2026-08-01' AND '2026-08-31'

Executed SQL (sha 87ad636e79aafb72)

SELECT
  SUM(
    CASE
      WHEN CAST(day AS DATE) BETWEEN '2026-08-01' AND '2026-08-15'
      THEN ggr_eur
      ELSE 0
    END
  ) AS ggr_first_half,
  SUM(
    CASE
      WHEN CAST(day AS DATE) BETWEEN '2026-08-16' AND '2026-08-31'
      THEN ggr_eur
      ELSE 0
    END
  ) AS ggr_second_half
FROM rpt_daily_ggr
WHERE
  CAST(day AS DATE) BETWEEN '2026-08-01' AND '2026-08-31'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT COUNT(CASE WHEN kyc_status = 'pending' THEN 1 END) * 1.0 / COUNT(*) AS share_pending_kyc FROM players

Executed SQL (sha 444cbeb981aaf75e)

SELECT
  COUNT(CASE WHEN kyc_status = 'pending' THEN 1 END) * 1.0 / COUNT(*) AS share_pending_kyc
FROM players
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT COUNT(*) AS self_excluded_count FROM players WHERE self_excluded = TRUE

Executed SQL (sha 3d89362e4d92ac80)

SELECT
  COUNT(*) AS self_excluded_count
FROM players
WHERE
  self_excluded = TRUE
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT p.vip_tier, SUM(r.ggr_eur) / COUNT(DISTINCT p.player_id) AS avg_ggr_per_player FROM rpt_daily_ggr r JOIN players p ON r.active_players > 0 AND p.player_id IN (SELECT DISTINCT player_id FROM bets WHERE CAST(ts AS DATE) = '2026-08-20') GROUP BY p.vip_tier ORDER BY avg_ggr_per_player DESC LIMIT 1

Executed SQL (sha fbc2b2f6c245d1c3)

SELECT
  p.vip_tier,
  SUM(r.ggr_eur) / COUNT(DISTINCT p.player_id) AS avg_ggr_per_player
FROM rpt_daily_ggr AS r
JOIN players AS p
  ON r.active_players > 0
  AND p.player_id IN (
    SELECT DISTINCT
      player_id
    FROM bets
    WHERE
      CAST(ts AS DATE) = '2026-08-20'
  )
GROUP BY
  p.vip_tier
ORDER BY
  avg_ggr_per_player DESC
LIMIT 1

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT COUNT(*) AS failed_deposits_count, (COUNT(*) * 1.0 / NULLIF((SELECT COUNT(*) FROM deposits WHERE status = 'settled' AND CAST(ts AS DATE) BETWEEN DATE '2026-07-21' AND DATE '2026-08-20'), 0)) AS failed_deposits_share FROM deposits WHERE status != 'settled' AND CAST(ts AS DATE) BETWEEN DATE '2026-07-21' AND DATE '2026-08-20'

Executed SQL (sha d58749e8db28b7de)

SELECT
  COUNT(*) AS failed_deposits_count,
  (
    COUNT(*) * 1.0 / NULLIF(
      (
        SELECT
          COUNT(*)
        FROM deposits
        WHERE
          status = 'settled'
          AND CAST(ts AS DATE) BETWEEN CAST('2026-07-21' AS DATE) AND CAST('2026-08-20' AS DATE)
      ),
      0
    )
  ) AS failed_deposits_share
FROM deposits
WHERE
  status <> 'settled'
  AND CAST(ts AS DATE) BETWEEN CAST('2026-07-21' AS DATE) AND CAST('2026-08-20' AS DATE)
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT COUNT(CASE WHEN review_outcome IS NOT NULL THEN 1 END) * 1.0 / COUNT(*) AS share_manual_review FROM withdrawals WHERE CAST(ts AS DATE) BETWEEN '2026-08-01' AND '2026-08-31'

Executed SQL (sha 6c8e5a7183dfe295)

SELECT
  COUNT(CASE WHEN NOT review_outcome IS NULL THEN 1 END) * 1.0 / COUNT(*) AS share_manual_review
FROM withdrawals
WHERE
  CAST(ts AS DATE) BETWEEN '2026-08-01' AND '2026-08-31'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT day, campaign, SUM(bonus_cost_eur) AS total_bonus_cost_eur FROM rpt_daily_bonus_cost WHERE day BETWEEN '2026-07-25' AND '2026-07-31' GROUP BY day, campaign

Executed SQL (sha 4a92cc30e9c49ecd)

SELECT
  day,
  campaign,
  SUM(bonus_cost_eur) AS total_bonus_cost_eur
FROM rpt_daily_bonus_cost
WHERE
  day BETWEEN '2026-07-25' AND '2026-07-31'
GROUP BY
  day,
  campaign
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT campaign, SUM(bonus_cost_eur) AS total_bonus_cost_eur FROM rpt_daily_bonus_cost WHERE day BETWEEN '2026-07-01' AND '2026-07-31' GROUP BY campaign ORDER BY total_bonus_cost_eur DESC LIMIT 1

Executed SQL (sha 55a07e4bca763415)

SELECT
  campaign,
  SUM(bonus_cost_eur) AS total_bonus_cost_eur
FROM rpt_daily_bonus_cost
WHERE
  day BETWEEN '2026-07-01' AND '2026-07-31'
GROUP BY
  campaign
ORDER BY
  total_bonus_cost_eur DESC
LIMIT 1

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT p.country, AVG(d.amount_eur) AS average_deposit_size FROM deposits d JOIN players p ON d.player_id = p.player_id WHERE d.status = 'settled' AND CAST(d.ts AS DATE) BETWEEN '2026-08-01' AND '2026-08-31' GROUP BY p.country

Executed SQL (sha 7df4fb493101b86c)

SELECT
  p.country,
  AVG(d.amount_eur) AS average_deposit_size
FROM deposits AS d
JOIN players AS p
  ON d.player_id = p.player_id
WHERE
  d.status = 'settled' AND CAST(d.ts AS DATE) BETWEEN '2026-08-01' AND '2026-08-31'
GROUP BY
  p.country
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT COUNT(DISTINCT player_id) AS player_count FROM bets WHERE CAST(ts AS DATE) BETWEEN '2026-08-13' AND '2026-08-20'

Executed SQL (sha bc6246bc3a401fc0)

SELECT
  COUNT(DISTINCT player_id) AS player_count
FROM bets
WHERE
  CAST(ts AS DATE) BETWEEN '2026-08-13' AND '2026-08-20'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT method, SUM(amount_eur) AS total_deposit_value FROM deposits WHERE status = 'settled' GROUP BY method ORDER BY total_deposit_value DESC LIMIT 1

Executed SQL (sha 2527553612eef3eb)

SELECT
  method,
  SUM(amount_eur) AS total_deposit_value
FROM deposits
WHERE
  status = 'settled'
GROUP BY
  method
ORDER BY
  total_deposit_value DESC
LIMIT 1

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT p.country, SUM(r.ggr_eur) AS total_ggr_eur FROM rpt_daily_ggr r JOIN players p ON r.active_players = p.player_id WHERE CAST(r.day AS DATE) BETWEEN '2026-08-01' AND '2026-08-31' GROUP BY p.country ORDER BY total_ggr_eur DESC LIMIT 1

Executed SQL (sha cd1cc34fabc2633d)

SELECT
  p.country,
  SUM(r.ggr_eur) AS total_ggr_eur
FROM rpt_daily_ggr AS r
JOIN players AS p
  ON r.active_players = p.player_id
WHERE
  CAST(r.day AS DATE) BETWEEN '2026-08-01' AND '2026-08-31'
GROUP BY
  p.country
ORDER BY
  total_ggr_eur DESC
LIMIT 1

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT provider, SUM(stake_eur) AS total_stake_eur, SUM(payout_eur) AS total_payout_eur, SUM(stake_eur) - SUM(payout_eur) AS total_ggr_eur FROM bets WHERE CAST(ts AS DATE) BETWEEN '2026-07-21' AND '2026-08-20' GROUP BY provider

Executed SQL (sha 8bc5366954089c68)

SELECT
  provider,
  SUM(stake_eur) AS total_stake_eur,
  SUM(payout_eur) AS total_payout_eur,
  SUM(stake_eur) - SUM(payout_eur) AS total_ggr_eur
FROM bets
WHERE
  CAST(ts AS DATE) BETWEEN '2026-07-21' AND '2026-08-20'
GROUP BY
  provider
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT day, SUM(ggr_eur) AS total_ggr FROM rpt_daily_ggr WHERE day BETWEEN DATE '2026-08-07' AND DATE '2026-08-20' GROUP BY day ORDER BY day

Executed SQL (sha 4793e2e52c5b0e62)

SELECT
  day,
  SUM(ggr_eur) AS total_ggr
FROM rpt_daily_ggr
WHERE
  day BETWEEN CAST('2026-08-07' AS DATE) AND CAST('2026-08-20' AS DATE)
GROUP BY
  day
ORDER BY
  day
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT COUNT(*) AS bets_count FROM bets WHERE CAST(ts AS DATE) BETWEEN '2026-08-14' AND '2026-08-20'

Executed SQL (sha e07904229de77ab8)

SELECT
  COUNT(*) AS bets_count
FROM bets
WHERE
  CAST(ts AS DATE) BETWEEN '2026-08-14' AND '2026-08-20'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT SUM(amount_eur) AS total_settled_withdrawals FROM withdrawals WHERE status = 'settled' AND CAST(ts AS DATE) BETWEEN '2026-08-01' AND '2026-08-20'

Executed SQL (sha 82dd4c2ccd6f4b4d)

SELECT
  SUM(amount_eur) AS total_settled_withdrawals
FROM withdrawals
WHERE
  status = 'settled' AND CAST(ts AS DATE) BETWEEN '2026-08-01' AND '2026-08-20'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT SUM(bonus_cost_eur) AS total_bonus_cost_eur FROM rpt_daily_bonus_cost WHERE day BETWEEN '2026-08-01' AND '2026-08-20'

Executed SQL (sha b643eabc21466c5b)

SELECT
  SUM(bonus_cost_eur) AS total_bonus_cost_eur
FROM rpt_daily_bonus_cost
WHERE
  day BETWEEN '2026-08-01' AND '2026-08-20'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT SUM(net_deposits_eur) AS net_deposits FROM rpt_daily_cashflow WHERE CAST(day AS DATE) BETWEEN '2026-07-01' AND '2026-07-31'

Executed SQL (sha 517ea360eb839312)

SELECT
  SUM(net_deposits_eur) AS net_deposits
FROM rpt_daily_cashflow
WHERE
  CAST(day AS DATE) BETWEEN '2026-07-01' AND '2026-07-31'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT SUM(net_deposits_eur) AS net_deposits FROM rpt_daily_cashflow WHERE day BETWEEN '2026-08-14' AND '2026-08-20'

Executed SQL (sha 806d2048de7fd772)

SELECT
  SUM(net_deposits_eur) AS net_deposits
FROM rpt_daily_cashflow
WHERE
  day BETWEEN '2026-08-14' AND '2026-08-20'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT SUM(ggr_eur) AS total_ggr FROM rpt_daily_ggr WHERE day BETWEEN '2026-07-01' AND '2026-07-31'

Executed SQL (sha f55fb18eb1546ee0)

SELECT
  SUM(ggr_eur) AS total_ggr
FROM rpt_daily_ggr
WHERE
  day BETWEEN '2026-07-01' AND '2026-07-31'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT SUM(ggr_eur) AS total_ggr FROM rpt_daily_ggr WHERE day BETWEEN '2026-08-01' AND '2026-08-20'

Executed SQL (sha e46fb98abd256f7f)

SELECT
  SUM(ggr_eur) AS total_ggr
FROM rpt_daily_ggr
WHERE
  day BETWEEN '2026-08-01' AND '2026-08-20'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT sum(amount_eur) AS withdrawals_eur FROM withdrawals WHERE ts BETWEEN '2026-08-14' AND '2026-08-20 23:59:59'

Executed SQL (sha 836b11df69439f4b)

SELECT
  SUM(amount_eur) AS withdrawals_eur
FROM withdrawals
WHERE
  ts BETWEEN '2026-08-14' AND '2026-08-20 23:59:59'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT p.email, sum(d.amount_eur) AS total FROM players p JOIN deposits d ON d.player_id = p.player_id GROUP BY 1 ORDER BY 2 DESC LIMIT 10

SELECT p.email, sum(d.amount_eur) AS total FROM players p JOIN deposits d ON d.player_id = p.player_id GROUP BY 1 ORDER BY 2 DESC LIMIT 10

Sent to the user

Grade this turn

SQL attempts

Sent to the user

Grade this turn

Inbound screening

blocked by pattern: ignore (all |any |your )?(previous|prior|above|earlier) (instructions|prompts|rules)

Sent to the user

Grade this turn

SQL attempts

Sent to the user

Grade this turn

SQL attempts

Sent to the user

Grade this turn

SQL attempts

SELECT day, campaign, SUM(bonus_cost_eur) AS total_bonus_cost_eur FROM rpt_daily_bonus_cost WHERE day BETWEEN '2026-07-25' AND '2026-07-31' GROUP BY day, campaign ORDER BY day, campaign

Executed SQL (sha 133ee41e46287c43)

SELECT
  day,
  campaign,
  SUM(bonus_cost_eur) AS total_bonus_cost_eur
FROM rpt_daily_bonus_cost
WHERE
  day BETWEEN '2026-07-25' AND '2026-07-31'
GROUP BY
  day,
  campaign
ORDER BY
  day,
  campaign
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT SUM(amount_eur) AS total_settled_withdrawals FROM withdrawals WHERE status = 'settled' AND CAST(ts AS DATE) BETWEEN '2026-08-14' AND '2026-08-20'

Executed SQL (sha 1dcbd30516216356)

SELECT
  SUM(amount_eur) AS total_settled_withdrawals
FROM withdrawals
WHERE
  status = 'settled' AND CAST(ts AS DATE) BETWEEN '2026-08-14' AND '2026-08-20'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT provider, SUM(stake_eur) AS total_stake, SUM(payout_eur) AS total_payout, SUM(ggr_eur) AS total_ggr FROM bets JOIN rpt_daily_ggr ON bets.ts::DATE = rpt_daily_ggr.day WHERE bets.ts BETWEEN '2026-07-21' AND '2026-08-20' GROUP BY provider

SELECT
  provider,
  SUM(bets.stake_eur) AS total_stake,
  SUM(rpt_daily_ggr.payout_eur) AS total_payout,
  SUM(rpt_daily_ggr.ggr_eur) AS total_ggr
FROM bets
JOIN rpt_daily_ggr
  ON CAST(bets.ts AS DATE) = rpt_daily_ggr.day
WHERE
  bets.ts BETWEEN '2026-07-21' AND '2026-08-20'
GROUP BY
  provider

Executed SQL (sha 85a2f6048864009f)

SELECT
  provider,
  SUM(bets.stake_eur) AS total_stake,
  SUM(rpt_daily_ggr.payout_eur) AS total_payout,
  SUM(rpt_daily_ggr.ggr_eur) AS total_ggr
FROM bets
JOIN rpt_daily_ggr
  ON CAST(bets.ts AS DATE) = rpt_daily_ggr.day
WHERE
  bets.ts BETWEEN '2026-07-21' AND '2026-08-20'
GROUP BY
  provider
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn

SQL attempts

SELECT SUM(ggr_eur) AS total_ggr FROM rpt_daily_ggr WHERE day BETWEEN '2026-08-14' AND '2026-08-20'

Executed SQL (sha 8274f9ab036bafca)

SELECT
  SUM(ggr_eur) AS total_ggr
FROM rpt_daily_ggr
WHERE
  day BETWEEN '2026-08-14' AND '2026-08-20'
LIMIT 1000

Result

Checks

Sent to the user

Grade this turn