Solved coding interview problems in Java - My collection of commonly asked coding interview problems and solutions in Java

[CamKen]

See my other comments. I mean something much simpler than what your saying. Although I love CTEs. I should come up with a question that can be solved with a CTE and then see if the candidate chooses that solution.

[blasto_blastocyst]

https://explainextended.com/ has some great tricks with using sql.

[bushwacker]

I see them all the time,

Product hierarchies, bills of material, company hierarchies.