Some common SQL clauses used in conjuction with a SELECT query are as follows:
SELECT * FROM myDB.students WHERE graduation_year = 2019 ORDER BY studentID DESC;
SELECT COUNT(studentId), country FROM myDB.students WHERE country != "INDIA" GROUP BY country HAVING COUNT(studentID) > 5;