GirnarSoft interview question

Database queries like joins, query execution order