GitHub

From SQL to SPL：Calculate monthly account balance and fill in missing dates

WITH Accounts AS ( SELECT DISTINCT Name FROM trans ), Months AS ( SELECT DATEADD(MONTH, n, '2021-01-01') AS MonthStart FROM ( SELECT TOP (DATEDIFF(MONTH, '2021-01-01 ...
Analytics Insight

Frequently Used SQL Functions in Data Analysis

SQL is a tool that is widely used in the manipulation of data and featuring in the relational database. They are applied in querying, manipulating as well as reporting data and it is commonly used by ...
GitHub

Q&A_Glovo_SQL_Technical_Interview.md

--SQL Server code for Q1 resolution SELECT o.id AS order_id, p.latitude AS pickup_latitude, p.longitude AS pickup_longitude, d.latitude AS delivery_latitude, d.longitude AS delivery_longitude, ROUND( ...
note

[Snowflake] I tried writing a query to create a list of dates between specified dates

Sometimes I need to provide two dates and create a list of dates for that period, so I tried creating one in Snowflake as well. Query to get a list of dates for a specified period WITH arr AS ( SELECT ...
Microsoft

Excluding weekends and holidays in date differences in PowerApps

The first part of the problem to calculate the difference in business days is to exclude the weekends in the calculation. To start with that, we first need to calculate the number of whole weeks ...