Created and partially edited the dummy Database downloaded from GitHub having tables Users, Photos, Likes, Follows, Tags, Comments, Photo-Tags. Performed Some queries to solve the problems like –
• Reward the 5 oldest users.
• Day of week most users registered to schedule an Ad campaign.
• Target Inactive users who never posted a photo via email campaign
• Award contest for getting the most likes on a single photo.
• Investors want to know the average time users post a photo.
• User’s rankings by posting higher to lower.
• No. of users posted at least once.
• The brand wants to know the top 5 most commonly used hashtags.
• Problems with bots – User liked every single photo.
• Problems with celebrities – User Never commented on photo.