QualityKiosk interview question

Asked about my projects, questions in SQL basic Joins