school

thing1's amazing school repo
Log | Files | Refs | Submodules | README

1.sql (188B)

      1 CREATE TABLE member (
      2 	TEXT MEMBERID,
      3 	TEXT FORENAME,
      4 	TEXT LASTNAME,
      5 	INT MAXBOOKS
      6 	DOB DATEOFBIRTH
      7 )
      8 
      9 SELECT BOOKID
     10 FROM BOOK
     11 WHERE AUTHOR = "DAVID FERGUSON"
     12 AND PRICE < 25
     13 ORDER DESC
     14 
     15