diff options
| author | Abigail <abigail@abigail.be> | 2020-11-05 18:57:27 +0100 |
|---|---|---|
| committer | Abigail <abigail@abigail.be> | 2020-11-06 01:27:18 +0100 |
| commit | d20ff6ddb07a5495329de800382dbd02d3fd1380 (patch) | |
| tree | bbd9229e56807aef991c7da73a672be02b4de9c3 /challenge-085/abigail/sql | |
| parent | 326705eb376c6731d9b7ce701dbdfe28bf68d46e (diff) | |
| download | perlweeklychallenge-club-d20ff6ddb07a5495329de800382dbd02d3fd1380.tar.gz perlweeklychallenge-club-d20ff6ddb07a5495329de800382dbd02d3fd1380.tar.bz2 perlweeklychallenge-club-d20ff6ddb07a5495329de800382dbd02d3fd1380.zip | |
SQL solution for week 85/part 1.
Diffstat (limited to 'challenge-085/abigail/sql')
| -rw-r--r-- | challenge-085/abigail/sql/ch-1.sql | 16 | ||||
| -rw-r--r-- | challenge-085/abigail/sql/ch-1.table | 4 |
2 files changed, 20 insertions, 0 deletions
diff --git a/challenge-085/abigail/sql/ch-1.sql b/challenge-085/abigail/sql/ch-1.sql new file mode 100644 index 0000000000..796f7f1a86 --- /dev/null +++ b/challenge-085/abigail/sql/ch-1.sql @@ -0,0 +1,16 @@ +-- +-- See the file ch-1.table for the definition of the used table. +-- +-- Assumes each number of the input is on a separate row. +-- + +SELECT COUNT(*) + FROM (SELECT 1 + FROM Numbers t1, + Numbers t2, + Numbers t3 + WHERE t1 . id > t2 . id + AND t2 . id > t3 . id + AND 1 < t1 . value + t2 . value + t3 . value + AND t1 . value + t2 . value + t3 . value < 2 + LIMIT 1) diff --git a/challenge-085/abigail/sql/ch-1.table b/challenge-085/abigail/sql/ch-1.table new file mode 100644 index 0000000000..bb61916024 --- /dev/null +++ b/challenge-085/abigail/sql/ch-1.table @@ -0,0 +1,4 @@ +CREATE TABLE Numbers ( + id integer PRIMARY KEY, + value float +) |