/Tinder-Case-Study

Amazing Data exploration and extract astounding insight in my sql database management system

Tinder-Case-Study

  • You are building an application like tinder, consider the following scenarios:
  • There will be multiple users
  • Users can right swipe each other to send dating request
  • Users can send any number of requests to other users
  1. Convert the above business scenario to database tables
  2. Write a query to print the name and details of all the users to whom a particular user has sent request.
  3. Write a query to find the name of the user who has sent 2nd most number of requests, also print the count.
  4. Homework - Find the name of the user who has received min number of requests
  5. Find all the matches for a particular user