Practice - Social Media Engagement Analysis

social-media

Dataset

The dataset contains information about social media posts including...

  1. Post_ID: Unique identifier for each social media post.
  2. Post_Content: Textual content or description of the post shared on social media.
  3. Post_Type: Type of the post (e.g., text, image, video).
  4. Likes: Number of likes received on the post.
  5. Comments: Number of comments received on the post.
  6. Shares: Number of shares received on the post.
  7. Timestamp: Date and time when the post was shared on social media.

You can get a copy of the dataset here

Instructions

For this assignment, you are expected to use the SQL editor below to write and run your SQL queries.

  1. Explore the provided dataset to have an idea of what it represent.
  2. Create a table called engagement.
  3. Insert the dataset into the engagements table by copying and using this insert command
  4. Analyze the engagement metrics (likes, comments, shares) of the social media posts using SQL queries.
    • Calculate total likes, average comments per post, and total shares for each post type
  5. Include comments in your script to explain each query and its purpose.

Submission Guidelines:

  • Download your SQL query file to your computer.
    • Click on elipsis icon at the top-right of your onecompiler editor and select download. ./databases-and-sql/download.png
  • Attach the downloaded file below and submit.
    • There is no external submission for this project. Please ignore the Incomplete status for external submission.