HP Inc. interview question

SQL join related questions and basic logic questions