Skip to content

tomtranjr/instagram_db_clone_sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 

Repository files navigation

SQL Instagram Project

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.

Questions Answered

  1. Oldest users: Find the 5 earliest account registrations.
  2. Ad timing: Which day of the week has the most registrations?
  3. Inactive users: Who never posted a photo?
  4. Top photo: Which user owns the single most-liked photo?
  5. Posting cadence: How many times does the average user post?
  6. Popular topics: What are the top 5 most-used hashtags?
  7. Potential bots: Which users liked every post?

About

SQL Instagram Project from Udemy, "The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert" by Colt Steele

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors