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