Instagram Clone Project

In this project, we'll investigate a database by using joins and find answers for questions like :

• What day of the week do most users register on?
• Which users have not posted any photos?
• Which users liked every single photo on the clone website?

Authors

• @beneyup

Tables that we'll create:

• users
• photos
• follows
• comments
• likes
• tags
• photo_tags

Warnings

These two queries are used to fix a problem with the group by function, use them if needed

-- SET @@sql_mode='';

-- SET @old_sql_mode=@@sql_mode;