I have been asked basic questions based on my resume and then as I was comfortable with SQL so I have been asked a SQL query which was using joins, group by, as well as limit(Fully loaded query). It was good experience for me.