Tip 1 : practice ample of question on stratascratch and hackerrank
Tip 2 : practice ample gusstimates
Tip 1 : try to have some internship experience
Tip 2 : try to include some real life usecase of data analytics
Write a query to return date vs daily active users on the platform. Return only the dates having an odd number of daily active users. A user is considered active if they have completed an order on a particular date
Tip 1 : practice joins between table
Tip 2 : practice question of nesting queries
Write a query to display top three buyers whose orders are marked completed
You have 3 switches and 1 fan. The switches are outside the room and fan is inside. You can go into room once and once you go you cannot touch the switches. Now you need to figure out which switch turns on the fan
Tip 1 : Practice aptitude question
Given are ten balls, the task is to place these 10 balls in five lines such that each line contains exactly 4 balls.
Find the most expensive products on Amazon for each product category. Output category, product name and the price (as a number)

Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
What is recursion?