How to Filter Specific URLs in SQL: Using regexp_contains
When managing or analyzing web analytics data, you often need to exclude test URLs or… Read More »How to Filter Specific URLs in SQL: Using regexp_contains
SQL
String Concatenation in BigQuery: Comparing CONCAT Function and || Operator
In BigQuery, there are two main ways to concatenate strings: the CONCAT function and the… Read More »String Concatenation in BigQuery: Comparing CONCAT Function and || Operator
Mastering _TABLE_SUFFIX in BigQuery: Query Multiple Daily Tables with Ease
Let’s explore the _TABLE_SUFFIX feature in BigQuery SQL, which is frequently used and particularly helpful… Read More »Mastering _TABLE_SUFFIX in BigQuery: Query Multiple Daily Tables with Ease
SQL DELETE vs TRUNCATE – Deleting Data
Deleting data is always an exciting (or nerve-wracking?) task! In this article, we will explore… Read More »SQL DELETE vs TRUNCATE – Deleting Data
SQL QUALIFY – Filtering Data More Precisely with Window Functions
In this article, we will explore how to use the SQL QUALIFY clause with window… Read More »SQL QUALIFY – Filtering Data More Precisely with Window Functions
SQL SELECT – Removing Duplicates and Excluding Specific Columns
In this article, we will explain two commonly used SQL query features: SELECT DISTINCT and… Read More »SQL SELECT – Removing Duplicates and Excluding Specific Columns
[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
[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 RANK() and DENSE_RANK()
[SQL Interview] Differences Between LEAD() and LAG()
In a data analyst interview, various questions can be asked to evaluate your data analysis… Read More »[SQL Interview] Differences Between LEAD() and LAG()
SQL LAG Function Example: Analyzing Cancellation Rates in BigQuery
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