CODE EXAMPLE FOR SQL

order by with where clause in mysql

SELECT expressions  
FROM tables  
[WHERE conditions]  
ORDER BY expression [ ASC | DESC ];