-- sqlite3 --

CREATE TABLE lotto (Value INT NOT NULL);

INSERT INTO lotto VALUES
 (1), (2), (3), (4), (5), (6), (7), (8), (9), (10),
(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),
(21),(22),(23),(24),(25),(26),(27),(28),(29),(30),
(31),(32),(33),(34),(35),(36),(37),(38),(39),(40),
(41),(42),(43),(43),(45),(46),(47),(48),(49);

-- SELECT * FROM lotto ORDER BY RANDOM() LIMIT 6;

SELECT * FROM ( SELECT * FROM lotto ORDER BY RANDOM() LIMIT 6 ) ORDER BY Value;
