Chapter 9 - SQL

Each field in a table, has a data type
- Common data types include text/alphanumeric, character, boolean, integer, real and date/time
- Each table has a primary key field which acts as a unique identifier
  - Each item of data in this field is unique
  - Duplicate data items would be blocked if they were entered into the primary key field
- Because the items of data are unique within the primary key field they can be used to identify individual records [EG. CUSTOMER ID IN THIS CASE]
SQL -
- SQL statements follow this structure:
  - SELECT the fields you want to display
  - FROM the table/tables containing the data you wish to search
  - WHERE the search criteria
OR and AND are also valid

ORDER BY _____ ASC/DESC [The blank must be filled by age or name or whatever u are sorting]

SUM = add numerical data

COUNT = Count number of items
```
Eg. 1
SELECT Whatever, Whatever [Selecting the things you need]
FROM MainName [Main Sheet]
WHERE Whatever > Something [Condition]
ORDER BY Something ASC [Ascending]

Eg. 2
COUNT(WHATEVER)
FROM SHEET
WHERE Price > 100

Eg. 3 
SUM (QUANTITY)
FROM SHEET 
WHERE PRICE > 10
```