This article covers the most common SQL JOIN interview questions, how to answer them, and what you need to know about JOINs to join the desired company.
STRING_AGG is a rather rarely used SQL aggregation function but it sometimes comes useful when solving data science interview tasks. An example of this is the recent and very tasty interview question from Amazon that deals with some cookbook titles.