The clauses MUST appear in the order shown above.
Code Example:1 USE world;
2 SELECT name
3 FROM city
4 WHERE CountryCode = “AFG”
5 ORDER BY name
6 LIMIT 3
Results:
Let us break the statement line by line:
USE world;
SELECT name
FROM city
ORDER BY name
LIMIT 5;
Table 1. Column Specifications
Source  Option  Syntax 

Base Table Value 
Show all columns 

Base Table Value 
Column Name 
Commaseparated list of column names 
Calculated Value 
Calculation result 
Arithmetic expression 
Calculated Value 
Calculation result 
Functions 
This content is provided to you freely by EdTech Books.
Access it online or download it at https://edtechbooks.org/learning_mysql/the_five_clauses_of_.