Instagram Database Clone

Total USERS=100
Total Photos=257
Total Comments=7623
Total Likes=7488
Total follows=8782
Total tags=21
Total photo_tags=501

Problems

1. We want to reward our users who have been around the longest.Find the 5 oldest users.
2. What day of the week do most users register on?We need to figure out when to schedule an ad campgain
3. We want to target our inactive users with an email campaign.Find the users who have never posted a photo
4. We're running a new contest to see who can get the most likes on a single photo.
5. Our Investors want to know.How many times does the average user post?
6. A brand wants to know which hashtags to use in a post.What are the top 5 most commonly used hashtags?
7. We have a small problem with bots on our site..Find users who have liked every single photo on the site
8. We also have a problem with celebrities.Find users who have never commented on a photo