Today, I took a test for the role of Business Analyst at Meesho. The test consisted of three questions, with the first two being moderate in difficulty compared to the third. The first two questions were multiple-choice, requiring me to find bugs in the code. However, the third question was significantly more challenging, as it required writing an advanced SQL query, which was something I had never encountered before.
I understand that it's common for startups to set challenging test papers, but I'm looking for advice on how to tackle advanced SQL queries and how to practice them effectively
Other than practising the SELECT, UPDATE, INSERT and DELETE SQLS, which are mainly for common use cases, you can try out other techniques to perform advanced queries. Here are some of the most advanced SQL techniques you can practice to crack the business analyst role, next time.
Window Functions: If you want to calculate a “window” of data which is defined by a table’s specific subset, you can use the window functions.
Recursive Queries: This technique helps you perform hierarchical or repetitive computations on data organised in a tree- or graph-like style. If you want to calculate the estimated cost of a string of interconnected transactions, you can use this method.
Common Table Expressions: Using this technique, you can create a temporary-named result that can be used in later queries within the session. If you can’t manage a complex query, with this method you can break it into simpler and easy-to-manage parts.
Thank.you
I will practice these types of questions
But in reality they are not using it
Hi Grapes, I have an interview with Meesho this week for the Associate Business Manager position. I'm curious if anyone here has experience in a similar role at Meesho? Specifically, I'd like to know what types of case studies and logi...
Hi all,
I have an upcoming interview with Meesho for the SDE 1 Backend position, specifically the Machine Coding Round. If anyone has gone through this process, I would really appreciate it if you could share your experience. Any tips o...
Hey Guys !!!!! I have got the following offers from Swiggy and Meesho for an analytics role. Expecting another offer from Hike in the coming week. Please help me decide on which one to pick from an overall perspective.
My Profile:- 2...
Hiring for 3 Associate Manager (AM) roles in my span at Meesho.
The problem statements are in the Engagement charter, i.e., what can we do to keep users coming back to the app, discover relevant products, and drive purchase behaviour. ...
