Reports And Data interview questions

Initially they give one assignment and ask for just 2 round one assignment other manager round but after first round they ask for another round that is for pricing and in manager round wverything goes well and also get appreciate for the performance after 1 week they drop an email that we are moving ahead with other candidate profile which is in low range