Visited for an sql developer interview, it went we...

Visited for an sql developer interview, it went well first round technical and then call with US manager then HR discussion about salary, i have shared my expectations and other details. they called me on the next day and gave me a paper and asked to write some basing sql programs which you would have learned in college i have not prepared for that and got rejected. i think the interview rounds should be re ordered