In the last blog post, I left off using the DISTINCT statement along with aggregation. One thing to keep in mind with using the DISTINCT statement is that when they are used in conjunction with aggregate functions, they tend to slow the query time by a large amount. In today’s…

In this post, we will further examine how a CASE statement can be used to count multiple categories. In our previous post, we took a look at using a CASE statement to create a column telling us whether the total gross is over two and a half billion or not…

In the last part of the previous blog, I introduced the CASE statement which is capable of creating a new column and filling it with a value based on whether a condition is met or not. Let us further examine the CASE statement and what else it is capable of. …

In this blog post, I will be talking about several extremely useful functions that exist in SQL. GROUP BY The first of these is the GROUP BY function. The aggregate functions that we went through in the previous blogs like COUNT, AVG, and SUM aggregate across the entire dataset. If your goal…

Aggregate Functions In this blog post, I will be talking about the aggregate functions available in SQL. The first of which is the COUNT() function. COUNT() COUNT is an aggregate function in SQL that lets you count the rows in a particular column. SELECT COUNT(*) FROM ramenratings The above SQL…

Let us continue with a few more logical operators in this blog post. OR The OR logical operator in SQL allows you to select rows that meet at least one condition out of multiple conditions. It works similarly to the AND logical operator, where multiple conditions must be met. …

In this blog post, I will go further into some of the logical operators mentioned in the previous post. The first of these is the LIKE clause LIKE The LIKE logical operator lets you match similar values rather than values that are exactly the same. In the example below, the…

In my previous blog, I went over writing query statements, naming conventions for columns, formatting conventions for query statements, and also the LIMIT statement. In this blog, I will go over several more useful clauses that can be used and also show examples of them in use. WHERE The first clause…

In a SQL table, each column has a data type as an attribute that specifies the type of data of any object in it. Each column, variable, and expression has a related data type. …