Data Lemur

Solutions for Data Lemur Practice Interview Questions.

Useful Resources

• Postgresql
• Materialize
• Data.world
• Use the Index Luke
• SQL Bolt
• SQL Challenge
• SQL Format
• SQL Formatter
• SQL Practice
• SQL Practice Online
• SQL Practice Platform
• SQL Style Guide
• Omni Calculator - Probability calculator
• Stack Overflow - How to calculate date difference in Postgresql
• Postgresql Tutorial - Postgresql date part
• Neon Tech - A serverless Postgres platform.
• FreeCodeCamp - How to factorialize a number in javascript
• Programiz - Python Playground
• Stack Overflow - How do i count the trailing zeros in integer
• Python - Rstrip
• Stack Overflow - Built in module to calculate the least common multiple
• Scribbr - Pearson correlation coefficient
• Geeks for Geeks - Largest sum contiguous subarray
• Wikipedia - Maximum subarray problem
• Geeks for Geeks - SQL using clause
• W3 Schools - Cast
• Data Camp - SQL window functions cheat sheet
• SQL Shack - SQL server data type conversion methods performance comparison
• High Touch - SQL CTE (common table expression)
• Scaler - partition by in SQL
• Stack Overflow - rank versus row number
• Medium - How to calculate mode in SQL
• Stack Overflow - Compare phone numbers of multiple formats in SQL server
• W3 Schools - Func sqlserver left
• DB Visualizer - Understanding self joins in SQL
• Stack Overflow - Swap values for two rows in the same table in SQL server
• Modern SQL - Extract
• Stack Overflow - Timestamp difference in hours for Postgresql
• Stack Overflow - SQL query to maximize storage capacity in a warehouse for prime and non-prime
• Stack Overflow - How to use multiple columns in partition by and ensure no duplicate row is retur
• Codeacademy - Lead
• Medium - SQL lead and lag for consecutive problems
• Stack Overflow - Check if two selects are equivalent
• hightouch - SQL interval
• cogniniti - SQL date formats
• YouTube - Two Pointers in 7 minutes