Selecting from a Table

[Lecture] SELECT Statement

SELECT * FROM <TABLE_NAME>;
SELECT <COLUMN_NAME>, <COLUMN_NAME>, ... FROM <TABLE_NAME>;

[Lecture] WHERE Clause

SELECT <COLUMN_NAME>, <COLUMN_NAME>, ... FROM <TABLE_NAME>
WHERE <STATEMENT1> [AND|OR] <STATEMENT2>;