KKM Soft interview question

basic sql queries about join statements