In an SQL query, the FROM clause is always executed first, followed by the WHERE clause (if any), then the GROUP BY clause, then the HAVING clause (if any), then the SELECT clause, and finally the ORDER BY clause.

tuple can be recognized as a row of data in the following sections.

Lecture 7

Some basic statements

Comparison Operators

The SELECT statement

Computations

Selecting based on Summaries

Subqueries

Making Tables from Queries

Music Collection Example (inner join included)

Lecture 8

Relational Algebra

More about Relational Algebra

Select operator