• + 1 comment

    But my thought was the schema appears as if the challenge_id is unique and each challenge_id is associated with only one row. It would have been more intuitive if challenge_id, total_views, total_unique_views, date was provided in schema. Only when I relooked the table I was able to get it.