# Create Table Query
Write down CREATE TABLE (); as follows. Don't forget the ; at the end
```SQL
CREATE TABLE STUDENT(
);
```
Fill in the attributes
```SQL
CREATE TABLE STUDENT(
ID
FORENAME
SURNAME
DateOfBirth
);
```
Write down types (don't forget to use varchar() for Strings)
```SQL
CREATE TABLE STUDENT(
ID int
FORENAME varchar(50)
SURNAME varchar(50)
DateOfBirth date
);
```
Define key field(s)
```SQL
CREATE TABLE STUDENT(
ID int
FORENAME varchar(50)
SURNAME varchar(50)
DateOfBirth date
PRIMARY KEY (ID)
);
```
Check for commas and trailing semi colon
```SQL
CREATE TABLE STUDENT(
ID int,
FORENAME varchar(50),
SURNAME varchar(50),
DateOfBirth date,
PRIMARY KEY (ID)
);
```
# Select Query
Write down the following
```SQL
SELECT
FROM
WHERE
ORDER BY
```
Fill in the fields
```SQL
SELECT forename, surname, title
FROM
WHERE
ORDER BY
```
Fill in the tables
```SQL
SELECT forename, surname, title
FROM BORROWER, BOOK, LOAN
WHERE
ORDER BY
```
Fill in the conditions
```SQL
SELECT forename, surname, title
FROM BORROWER, BOOK, LOAN
WHERE datereturned = null
ORDER BY
```
Is there a link needed?
```SQL
SELECT forename, surname, title
FROM BORROWER, BOOK, LOAN
WHERE datereturned = null
AND BORROWER.BorrowerID = LOAN.BorrowerID
AND BOOK.BookID = BOOK.LoanID
ORDER BY
```
Is the table ordered?
```SQL
SELECT forename, surname, title
FROM BORROWER, BOOK, LOAN
WHERE datereturned = null
AND BORROWER.BorrowerID = LOAN.BorrowerID
AND BOOK.BookID = BOOK.LoanID
ORDER BY title
```