Snippets

Reuseable code snippets collected by me

SQL - BigQuery - Optimized Query

SQL - BigQuery - Optimized Query

BigQuery - Run parallel tasks to dataframes

Find a string starts with vowel in a sentence.

SQL - Previous month sales using Lag, GroupBy

An interview question to write a query to get the below output

SQL - Least() and Sum() only 5 values out of six to make average()

SQL - Least() and Sum() only 5 values out of six

SQL - Top asked SQL questions

Query to use group by, distinct, date functions

SQL - Inner Join on duplicate keys column

An interview question to do a inner join on table A and B with duplicate keys

SQL - Self, Cross Join - Match Fixture

Query to schedule a match between each team from same table

Python - find text starts with vowel

Find a string starts with vowel in a sentence.