Query editor
1SELECT 2 date,3 new_approved AS created_duels,4 resolved AS resolved_duels5FROM dune.duelduck.dataset_duel_predictions_daily6WHERE date < (SELECT MAX(date) FROM dune.duelduck.dataset_duel_predictions_daily)7ORDER BY date ASC;
SELECT
date,
new_approved AS created_duels,
resolved AS resolved_duels
FROM dune.duelduck.dataset_duel_predictions_daily
WHERE date < (SELECT MAX(date) FROM dune.duelduck.dataset_duel_predictions_daily)
ORDER BY date ASC;