Posts tagged 'sql'}

Create a custom Product Conversion Funnel Report with ShopifyQL Notebooks
ShopifyQL Notebooks enables any Plus store to create custom reports using SQL.

#shopify #sql
Creating IF functionality with SQL using CASE & subqueries
How combining CASE and a subquery can give you SQL IF statement functionality

#sql
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.

#sql
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.

#sql

#sql