Rohit SharmaFind the top-ranked songs for the past 20 years.Find all the songs that were top-ranked (at first position) at least once in the past 20 yearsJun 16Jun 16
Rohit SharmaAcceptance Rate By DateWhat is the overall friend acceptance rate by date? Your output should have the rate of acceptances by the date the request was sent. Order…Jun 16Jun 16
Rohit SharmaSMS Confirmations From UsersMeta/Facebook sends SMS texts when users attempt to 2FA (2-factor authenticate) into the platform to log in. In order to successfully 2FA…Jun 16Jun 16
Rohit SharmaMost Active Users On MessengerMeta/Facebook Messenger stores the number of messages between users in a table named ‘fb_messages’. In this table ‘user1’ is the sender…Jun 16Jun 16
Rohit SharmaExpensive ProjectsGiven a list of projects and employees mapped to each project, calculate by the amount of project budget allocated to each employee . The…Jun 16Jun 16
Rohit SharmaRisky ProjectsIdentify projects that are at risk for going overbudget. A project is considered to be overbudget if the cost of all employees assigned to…Jun 16Jun 16
Rohit SharmaClass PerformanceYou are given a table containing assignment scores of students in a class. Write a query that identifies the largest difference in total…Jun 16Jun 16
Rohit SharmaCities With The Most Expensive HomesWrite a query that identifies cities with higher than average home prices when compared to the national average. Output the city names.Jun 16Jun 16
Rohit SharmaNew ProductsYou are given a table of product launches by company by year. Write a query to count the net difference between the number of products…Jun 16Jun 16
Rohit SharmaFinding User PurchasesWrite a query that’ll identify returning active users. A returning active user is a user that has made a second purchase within 7 days of…Jun 16Jun 16