What data do you usually use for your research, and how do you decide which sources to trust?
Using the provided source, review, and observation data, identify the active sources that meet the reliability criteria below.
source_name, source_type, review_count, average_reliability_score, and verified_observation_count| Column | Type | Description |
|---|---|---|
| source_idPK | INT | Unique identifier for a research source |
| source_name | VARCHAR(150) | Name of the research source |
| source_type | VARCHAR(60) | Classification of the source |
| coverage_area | VARCHAR(80) | Primary market or subject area covered |
| is_active | BOOLEAN | Whether the source is currently approved for use |
| Column | Type | Description |
|---|---|---|
| review_idPK | INT | Unique identifier for a source review |
| source_id | INT | Reviewed research source |
| review_date | DATE | Date of the review |
| reliability_score | DECIMAL(3,1) | Reliability score from 1.0 to 5.0 |
| reviewer_team | VARCHAR(80) | Team that completed the review |
| Column | Type | Description |
|---|---|---|
| observation_idPK | INT | Unique identifier for an observed data point |
| source_id | INT | Source associated with the observation |
| observation_date | DATE | Date of the observation |
| metric_name | VARCHAR(100) | Name of the observed metric |
| observed_value | DECIMAL(12,2) | Observed numeric value |
| independently_verified | BOOLEAN | Whether the observation was confirmed independently |