![](https://lucy-the-marketer.kr/wp-content/uploads/2020/07/database-schema-1895779_640.png)
[SQL Interview] Differences Between CTE and Subquery
In a data analyst interview, various questions can be asked to assess data analysis and… Read More »[SQL Interview] Differences Between CTE and Subquery
In a data analyst interview, various questions can be asked to assess data analysis and… Read More »[SQL Interview] Differences Between CTE and Subquery
In a data analyst interview, various questions can be asked to evaluate your data analysis… Read More »[SQL Interview] Differences Between RANK() and DENSE_RANK()
In a data analyst interview, various questions can be asked to evaluate your data analysis… Read More »[SQL Interview] Differences Between LEAD() and LAG()
Introduction In this article, we will use the LAG function in BigQuery to analyze commission… Read More »SQL LAG Function Example: Analyzing Cancellation Rates in BigQuery
Introduction: The Significance of JSON in Data Analysis In today’s digital age, JSON (JavaScript Object… Read More »[BigQuery] Mastering SQL for JSON Data Handling: A Practical Guide
In this post, we’ll explore how to declare and assign variables using the SET and… Read More »How to use SQL SET/DECLARE Statements (with example)
In this article, we’ll learn how to handle dates using SQL. We’ll take a closer… Read More »SQL date functions with examples
Let’s move further in the aggregations functions that covered in the last article. In this… Read More »SQL (5) GROUP BY and HAVING
In the last article, we’ve talked about the basics of SELECT and WHERE clauses. In… Read More »SQL (4) Filtering (BETWEEN, IN, OR, NOT)
Let’s learn how to create a simple table. ■ CREATE TABLE CREATE TABLE clause create… Read More »SQL (3) Creating a table