diff options
| author | Abigail <abigail@abigail.be> | 2021-03-22 19:52:46 +0100 |
|---|---|---|
| committer | Abigail <abigail@abigail.be> | 2021-03-22 19:52:46 +0100 |
| commit | 7ee8eee88d4037f3084a16e6d848f0078689c2e4 (patch) | |
| tree | cd9ecddf681db560f4e0e359f531c57eeb0dd1aa /challenge-105/abigail/sql/ch-1.sql | |
| parent | 33351134ef839b865463049d7ab478b26b1a2ffb (diff) | |
| download | perlweeklychallenge-club-7ee8eee88d4037f3084a16e6d848f0078689c2e4.tar.gz perlweeklychallenge-club-7ee8eee88d4037f3084a16e6d848f0078689c2e4.tar.bz2 perlweeklychallenge-club-7ee8eee88d4037f3084a16e6d848f0078689c2e4.zip | |
SQL solution for week 105, part 1
Diffstat (limited to 'challenge-105/abigail/sql/ch-1.sql')
| -rw-r--r-- | challenge-105/abigail/sql/ch-1.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/challenge-105/abigail/sql/ch-1.sql b/challenge-105/abigail/sql/ch-1.sql new file mode 100644 index 0000000000..33bff39b0c --- /dev/null +++ b/challenge-105/abigail/sql/ch-1.sql @@ -0,0 +1,14 @@ +-- +-- Run as: <database client> < ch-1.sql +-- after you've added the appropriate INSERT statements +-- before the SELECT statement. +-- + +CREATE TABLE Input ( + N DOUBLE NOT NULL, + k DOUBLE NOT NULL +); + +SELECT POW (k, 1 / N) + FROM Input + |