diff options
| author | Abigail <abigail@abigail.be> | 2020-11-08 19:40:05 +0100 |
|---|---|---|
| committer | Abigail <abigail@abigail.be> | 2020-11-08 19:40:05 +0100 |
| commit | 4e34dd5d0e89307aca9f4cd3bb6072c07f942ff1 (patch) | |
| tree | 52495c7853bf31c427ec26f500c66c5bed6753b4 /challenge-085/abigail/sql/ch-1.sql | |
| parent | 520db2cfca438cdc9a78932e5f479e28abee150b (diff) | |
| parent | ff7475c4559b1087f402725a7c526d3f780e3434 (diff) | |
| download | perlweeklychallenge-club-4e34dd5d0e89307aca9f4cd3bb6072c07f942ff1.tar.gz perlweeklychallenge-club-4e34dd5d0e89307aca9f4cd3bb6072c07f942ff1.tar.bz2 perlweeklychallenge-club-4e34dd5d0e89307aca9f4cd3bb6072c07f942ff1.zip | |
Merge branch 'master' of https://github.com/manwar/perlweeklychallenge-club
Diffstat (limited to 'challenge-085/abigail/sql/ch-1.sql')
| -rw-r--r-- | challenge-085/abigail/sql/ch-1.sql | 16 |
1 files changed, 16 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) |