azavea / azavea/osmesa-stat-server

Skip users 0 and 1 in hashtag_statistics.sql

Open
#32 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Shell
Stars
6
Forks
3
PR merge metrics
No merged PRs in 30d

Description

For consistency with country stats: https://github.com/azavea/osmesa-stat-server/blob/master/sql/country_statistics.sql#L8

Contributor guide

No contributing guide indexed for this repository

Research direction

Compare sql/hashtag_statistics.sql with sql/country_statistics.sql, especially the condition referenced around country_statistics.sql#L8. Confirm how users 0 and 1 are currently included, then make the hashtag statistics query apply the same exclusion and verify the resulting query matches the stated consistency requirement.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
1/5
Estimated time
Under an hour
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.