search

richardspirit / mtga_stats_beta

MTG Arena Statistics Tracker
0 stars 0 forks source link

Review database structure and queries #6

Open richardspirit opened 2 years ago

richardspirit commented 2 years ago

Inconsistencies in data requires a review of database and queries.

ex. Angelic Army - view most_wbd

richardspirit commented 2 years ago

SELECT deck, MAX(win_count) as max_win, day_of_week FROM mtga.wins_by_day WHERE deck=? AND deck IN (SELECT name FROM mtga.decks) GROUP BY deck, day_of_week ORDER BY win_count DESC LIMIT 1