SQL Project on ig-clone dataset.
Problems solved:
- Create an ER diagram.
- We Want to reward the user who has been around the longest, Find the oldest users.
- To target inactive users in an email ad campaign, find the users who have never posted a photo.
- Suppose you are running a contest to find out who got the most likes on a photo. Find out who won ?
- The investers want to know how many times does the average user post.
- A brand wants to know which hashtag to use in a post, find the top 5 most used hashtags.
- To find out if there are bots, find users who have liked every single photo on the site.
- Find the users who have created instagramid in may and select top 5 newest joinees from it ?
- Can you help me find the users whose name starts with c and ends with any number and have posted the photos as well as liked the photos.
- Demonstrate the top 30 user names to the company who have posted photos in the range of 3 AND 5.