In this project I have done basic analysis of dummy instagram application data using MySQL. The database has following tables :
- Users - details of the users like userid,name,account created date and time.
- likes - details of likes each photo has on the application - photo liked, who has liked it.
- photos - details of the photo posted like photo_id, user_id who posted it, when it was posted.
- tags - hashtags added to each photo.
Please have a look at projects file for details of the queries.