Posts

Answering Simple Questions in SQL Coding Interviews

An interviewer recently commented about 50% of initial coding interviews failing what seemed to be very simple questions. I take a look at the questions and demonstrate the best way to answer them.

Last updated on Mar 7, 2018 8 min read SQL

Query Stack Overflow for Top 5 Tags and Children Posts

I want to find the top 5 tags (by post count) on Stack Overflow and include the top 5 posts per tag by score. For this, I will use the Stack Exchange Data Explorer.

Last updated on Mar 6, 2018 10 min read SQL

Department Top Three Salaries

Given Employee and Department tables, we are asked to JOIN the tables and bring the top three employees (no ties) of each department.

Last updated on Jun 27, 2019 5 min read SQL

RStudio in Docker

An introduction to running RStudio within Docker.

Last updated on Mar 6, 2018 10 min read R, RStudio, Docker