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 | |
| parent | 073f1ce23d470bd85b0eb7497308f879ee214a48 (diff) | |
added homework
Diffstat (limited to 'comp/hw/112')
| -rw-r--r-- | comp/hw/112/1.sql | 15 | ||||
| -rw-r--r-- | comp/hw/112/2.sql | 8 |
2 files changed, 23 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 + + diff --git a/comp/hw/112/2.sql b/comp/hw/112/2.sql new file mode 100644 index 0000000..d584710 --- /dev/null +++ b/comp/hw/112/2.sql @@ -0,0 +1,8 @@ +INSERT INTO RACE +VALUES (3,"BOYS",80,"HURDLES",13:30) + +UPDATE ATHLETE +WHERE ATHLETENUMBER = 27 +AND RACENUMBER = 6 +TIMESET = 0:18.76 + |