Manchoju Raja Venkatesh#SQL_Challenge_17Given table users table shows userid level logindates. A user can have mutliple logins in a given date. Write a SQL query to get the userid…Jul 30Jul 30
Manchoju Raja Venkatesh#SQL_Challenge_16Write a SQL query to get the ratio(games_left_without_playing/games_joined) for the first7 days, 14 days, 21 days and 30 days for each…May 11May 11
Manchoju Raja Venkatesh#SQL_Challenge_15For a given week, find the number of users, retained users for each of the subsequent weeks. (WoW retention)May 11May 11
Manchoju Raja Venkatesh#SQL_Challenge_14Question statement : Given , is the table that contains user_id, their subscription start and end dates on a gaming platform. We need to…May 11May 11
Manchoju Raja Venkatesh#SQl_Challenge_13Write an SQL code to see if there are at least 3 consecutive males sitting together.May 5May 5
Manchoju Raja Venkatesh#SQL_Challenge_12Find the price of each item at the start of each month. It should be noted that when the price of an item on the 1st date of the month or…Feb 23Feb 23
Manchoju Raja VenkateshLeveraging the Stored Procedures in Referral CampaignsHere, in this blog, I would like to demonstrate how we can make the use of stored procedure to generate the automated daily/weekly report…Jan 20Jan 20
Manchoju Raja Venkatesh#SQL_Challenge_11Write an SQL query to print ids and their comment. The comment column goes as follows:Jan 7Jan 7