world-cup-predictions/wc-20140710-164509

4 rows where group = "a" sorted by cup descending

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi
6	6	Brazil	BRA	a	88.58	3.0129	0.6974	1	1	1	1
9	9	Cameroon	CMR	a	68.21	1.4582	1.1747	0	0	0	0
12	12	Croatia	CRO	a	77.6	2.0163	0.9858	0	0	0	0
25	25	Mexico	MEX	a	79.6	1.6241	0.5659	0	1	0	0

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "world-cup-predictions/wc-20140710-164509" (
"country" TEXT,
  "country_id" TEXT,
  "group" TEXT,
  "spi" REAL,
  "spi_offense" REAL,
  "spi_defense" REAL,
  "win_group" INTEGER,
  "sixteen" INTEGER,
  "quarter" INTEGER,
  "semi" INTEGER,
  "cup" INTEGER,
  "win" REAL
);