huxley@nb016161$ sqlite3 new-file.db
sqlite> CREATE TABLE rocon (hostname TEXT, fedora11 INT, pc012939 INT, pc008887 INT, pc012345 INT);
sqlite> INSERT INTO rocon VALUES ("pc012939", 1, 1, 0, 0);
sqlite> INSERT INTO rocon VALUES ("pc008887", 1, 0, 1, 0);
sqlite> INSERT INTO rocon VALUES ("pc012345", 1, 0, 0, 1);
sqlite> SELECT hostname FROM rocon WHERE (fedora11 AND NOT pc008887);
pc012939
pc012345
sqlite> .quit
ahuxley@nb016161$