Unverified solutions for Data Lemur Practice Interview Questions.
- Postgresql
- Materialize
- Data.world
- Use the Index Luke
- SQL Format
- SQL Formatter
- Omni Calculator - probability calculator
- Stack Overflow - how to calculate date difference in postgresql
- Postgresql Tutorial - postgresql date part
- Neon Tech - Neon is a serverless Postgres platform designed to help you build reliable and scalable applications faster.
- 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 common table expression cte
- Scaler - partition by in sql
- Stack Overflow - sql rank versus row number
- Medium - how to calculate mode in sql how to find most frequent value in a column
- 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 - daily think sql lead and lag for consecutive problems
- Stack Overflow - check if two selects are equivalent
- hightouch - sql interval
- cogniniti - sql date formats