I had way less trouble in college with relational algebra, compared with SQL. SQL is by no means intuitive. Projection, which is what you do last, comes first in the select statement. Then there are all the join types.

Relational algebra, which is what SQL is ultimately based on, is much more elegant.