S&P Global interview question

sql questions based on unique,select keyword