-- db data:
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE people("_row_id" INTEGER PRIMARY KEY AUTOINCREMENT, "_unique" TEXT NULL DEFAULT "", "class" TEXT NULL DEFAULT "", "keyword" TEXT NULL DEFAULT "" UNIQUE, "org_type" TEXT NULL DEFAULT "", "_index" TEXT NULL DEFAULT "", "race" TEXT NULL DEFAULT "", "name" TEXT NULL DEFAULT "", "last_seen" INTEGER NULL DEFAULT CURRENT_TIMESTAMP, "status" TEXT NULL DEFAULT "", "level" REAL NULL DEFAULT 0, "_violations" TEXT NULL DEFAULT "", "org" TEXT NULL DEFAULT "");
INSERT INTO "people" VALUES(194,'','warrior','bob','','','elf','bob','2013-06-28 00:04:31','',1.0,'','');
INSERT INTO "people" VALUES(195,'','thief','george','','','dwarf','George','2013-06-28 00:04:31','',15.0,'','');
INSERT INTO "people" VALUES(197,'','warrior','Bob','','','human','Bob','2013-06-28 00:04:31','',15.0,'','');
INSERT INTO "people" VALUES(198,'','warrior','Boba','','','human','Boba','2013-06-28 00:04:31','',15.0,'','');
INSERT INTO "people" VALUES(199,'','warrior','Bobb','','','human','Bobb','2013-06-28 00:04:31','',15.0,'','');
INSERT INTO "people" VALUES(200,'','warrior','Bobc','','','human','Bobc','2013-06-28 00:04:31','',15.0,'','');
INSERT INTO "people" VALUES(201,'','cleric','Frank','','','ogre','Frank','2013-06-28 00:04:31','',31.0,'','');
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('people',201);
CREATE INDEX idx_people_c_name ON people ("name");
CREATE UNIQUE INDEX idx_people_c_keyword ON people ("keyword");
COMMIT;

-- query:
SELECT * FROM people ORDER BY "level", "name" DESC;