Allscripts interview question

Sql basics