diff options
| author | standenboy <standenboy@StandenboyLAP.lan> | 2024-02-07 13:25:38 +0000 |
|---|---|---|
| committer | standenboy <standenboy@StandenboyLAP.lan> | 2024-02-07 13:25:38 +0000 |
| commit | e4864bf1cd9e192eb54e492aaf02a397e143539c (patch) | |
| tree | bed018816cb704e53839b1122081de799a6e5e8e /comp/hw/112/1.sql | |
| parent | 073f1ce23d470bd85b0eb7497308f879ee214a48 (diff) | |
added homework
Diffstat (limited to 'comp/hw/112/1.sql')
| -rw-r--r-- | comp/hw/112/1.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/comp/hw/112/1.sql b/comp/hw/112/1.sql new file mode 100644 index 0000000..9f3c213 --- /dev/null +++ b/comp/hw/112/1.sql @@ -0,0 +1,15 @@ +CREATE TABLE member ( + TEXT MEMBERID, + TEXT FORENAME, + TEXT LASTNAME, + INT MAXBOOKS + DOB DATEOFBIRTH +) + +SELECT BOOKID +FROM BOOK +WHERE AUTHOR = "DAVID FERGUSON" +AND PRICE < 25 +ORDER DESC + + |