comp/hw/112/1.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
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