Htoo LattSQL Part 11In the previous blog post, we explore the dataset that we will be using for the JOINS. We also ended with a simple JOIN statement that…3 min read·Mar 29, 2022----
Htoo LattSQL Part 10In the last blog post, I left off using the DISTINCT statement along with aggregation. One thing to keep in mind with using the DISTINCT…3 min read·Mar 29, 2022----
Htoo LattSQL Part 9In 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…3 min read·Feb 27, 2022----
Htoo LattSQL Part 8In 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…3 min read·Feb 27, 2022----
Htoo LattSQL Part 7In this blog post, I will be talking about several extremely useful functions that exist in SQL.3 min read·Feb 7, 2022----
Htoo LattSQL Part 5Let us continue with a few more logical operators in this blog post.3 min read·Jan 24, 2022----
Htoo LattSQL Part 4In this blog post, I will go further into some of the logical operators mentioned in the previous post.3 min read·Jan 16, 2022----
Htoo LattSQL PART 3In my previous blog, I went over writing query statements, naming conventions for columns, formatting conventions for query statements, and…3 min read·Jan 9, 2022----
Htoo LattSQL Part 2In 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…3 min read·Jan 1, 2022----