Xcaliber Infotech interview question

Basics of SQL, 2 problems to solve to check reasoning