Create a custom Product Conversion Funnel Report with ShopifyQL Notebooks
ShopifyQL Notebooks enables any Plus store to create custom reports using SQL.
Creating IF functionality with SQL using CASE & subqueries
How combining CASE and a subquery can give you SQL IF statement functionality
Using Common Table Expressions in SQL to Improve Your ETL Process
How and when to use common table expressions in SQL using a common sense approach.
Creating an SQL query where one column contains aggregated data from another table
An SQL exercise that goes through a work request, problem and solution.