search

richardspirit / mtga_stats

Originated as way to manage Magic The Gathering decks on MGTA so that I knew which decks were performing the best and which decks should be deleted.
GNU Lesser General Public License v3.0
1 stars 0 forks source link

Game Count #3

Closed richardspirit closed 3 years ago

richardspirit commented 3 years ago

Display Game Count for each deck

SQL: SELECT UID, count(results), deck FROM mgta.game_count;

richardspirit commented 3 years ago

I don't know why I have UID and a count removing both. Updated SQL

SELECT deck, results AS Count FROM mgta.game_count WHERE deck=?

richardspirit commented 3 years ago

Completed.