From d20ff6ddb07a5495329de800382dbd02d3fd1380 Mon Sep 17 00:00:00 2001 From: Abigail Date: Thu, 5 Nov 2020 18:57:27 +0100 Subject: SQL solution for week 85/part 1. --- challenge-085/abigail/sql/ch-1.sql | 16 ++++++++++++++++ challenge-085/abigail/sql/ch-1.table | 4 ++++ 2 files changed, 20 insertions(+) create mode 100644 challenge-085/abigail/sql/ch-1.sql create mode 100644 challenge-085/abigail/sql/ch-1.table 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 +) -- cgit