NOTE: This page is experimental. Bug reports to Query language is SQLite3.

Prepend rss. to the URL for an RSS feed, csv. to the URL for CSV output.

QUERY: SELECT COUNT(*), winlose FROM players WHERE player='barrycarter' GROUP BY 2 ORDER BY 1 DESC

To edit query (or if query above is munged), see textbox at bottom of page

Empty result may indicate error: I'm not sure why my error checking code isn't working.

Source code

COUNT(*) winlose
527 Won
524 Lost
49 Waiting

Enter query below (must start w/ SELECT):

Schema Raw SQLite3 db RSS feed for this query