The Big 6 of SQL: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

We'll review the key components of SQL queries, which will serve as the building blocks for many of the analyses you'll perform using SQL:
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
Learning just these 6 statements and clauses is a great start for anyone who wants to add SQL to their tool belt.
If you want to see more of this content, check out our Course Demos series here on RUclips.
Or check out our MySQL Data Analysis course:

[@skccharan]

Thank you for very good explanation

[@cassandraomorodion4297]

Thank you for this. Is there any chance of explaining case statement.

[@jbpauler]

Hi Cassandra, we may release a video here in the future. We also cover this concept in depth in our video course ‘MySQL Data Analysis’.
And here’s a quick example that may help…
www.linkedin.com/posts/johnpauler_sql-data-analytics-activity-6792054736578260992-bJdM

[@ifoodieTV]

Should or is it 🤔 a good habit to automatically add. The 6 elements to a SQL. To be on the safe side? Or does it depend on the client's requirements 🤔