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
+