Allscripts interview question

SQL questions are asked mainly