No, you are not correct.
There are different algorithms, depending on the DB server, indexes and data order (clustered PK), whether calculated values are joined or not etc.
As, suggested
here[
^], have a look at a query plan, which most SQL systems can create for a query, it should give you an idea what it does.
For more read
this[
^].