Check out example codes for "sql order of operations". It will help you in understanding the concepts better.

Code Example 1

SELECT DISTINCT column, AGG_FUNC(column_or_expression), …
FROM mytable
    JOIN another_table
      ON mytable.column = another_table.column
    WHERE constraint_expression
    GROUP BY column
    HAVING constraint_expression
    ORDER BY column ASC/DESC
    LIMIT count OFFSET COUNT;

Learn ReactJs, React Native from akashmittal.com