- 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
- Convert the above business scenario to database tables
- Write a query to print the name and details of all the users to whom a particular user has sent request.
- Write a query to find the name of the user who has sent 2nd most number of requests, also print the count.
- Homework - Find the name of the user who has received min number of requests
- Find all the matches for a particular user