1 files changed, 14 insertions, 0 deletions
diff --git a/challenge-246/arne-sommer/sql/ch-1.sql b/challenge-246/arne-sommer/sql/ch-1.sql
new file mode 100755
index 0000000000..fcf1d10e3e
--- /dev/null
+++ b/challenge-246/arne-sommer/sql/ch-1.sql
@@ -0,0 +1,14 @@
+-- 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;