From e4864bf1cd9e192eb54e492aaf02a397e143539c Mon Sep 17 00:00:00 2001
From: standenboy <standenboy@StandenboyLAP.lan>
Date: Wed, 7 Feb 2024 13:25:38 +0000
Subject: added homework

---
 comp/hw/112/1.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 comp/hw/112/1.sql

(limited to 'comp/hw/112/1.sql')

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
+
+
-- 
cgit v1.2.3

