Executing Queries

‘TODO’

SELECT * FROM table_name;

‘TODO’

Keywords and clauses include:

• WHERE
• DISTINCT
• GROUP BY
• HAVING
• ORDER BY
• JOIN
  • How joins are executed

For example:

SELECT first_column_name, second_column_name
FROM table_name
WHERE first_column_name > 1000;

‘TODO’