DataCamp interview question

Technical SQL question around when to use specific scenarios