Short SQL project based on "The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert" by Colt Steele.
Queries explore user behavior and content patterns in an Instagram-style dataset.
- Oldest users: Find the 5 earliest account registrations.
- Ad timing: Which day of the week has the most registrations?
- Inactive users: Who never posted a photo?
- Top photo: Which user owns the single most-liked photo?
- Posting cadence: How many times does the average user post?
- Popular topics: What are the top 5 most-used hashtags?
- Potential bots: Which users liked every post?