diff options
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 + + |