SQL is the language for all database queries. It is easy to start due to its structural characteristics, but sometimes, to get correct result SQL queries, especially for the beginner of SQL user, practic is needed to understand the possible situations.
At this article, Null, Count, Sum and Avg will be the focuses. The code is based on MySQL. Let’s start.