SQL Project on ig-clone dataset.

Problems solved:

1. Create an ER diagram.
2. We Want to reward the user who has been around the longest, Find the oldest users.
3. To target inactive users in an email ad campaign, find the users who have never posted a photo.
4. Suppose you are running a contest to find out who got the most likes on a photo. Find out who won ?
5. The investers want to know how many times does the average user post.
6. A brand wants to know which hashtag to use in a post, find the top 5 most used hashtags.
7. To find out if there are bots, find users who have liked every single photo on the site.
8. Find the users who have created instagramid in may and select top 5 newest joinees from it ?
9. 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.
10. Demonstrate the top 30 user names to the company who have posted photos in the range of 3 AND 5.