Interview Guides Experiences

Interview Guides

Aggregate Alerts by Site | Dataford Interview Questions

All questions/SQL & Data Manipulation

Aggregate Alerts by Site

Easy

JoinsGroup ByAggregations

Problem

Task

You are given two PostgreSQL tables from a Copeland monitoring workflow: sites and alerts. Write an SQL query that joins the tables and returns one row per site with the total number of alerts and the average alert severity. Include only active sites, and sort the result by total alerts descending, then by site name ascending.

Problem

Task

You are given two PostgreSQL tables from a Copeland monitoring workflow: sites and alerts. Write an SQL query that joins the tables and returns one row per site with the total number of alerts and the average alert severity. Include only active sites, and sort the result by total alerts descending, then by site name ascending.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Palantir technologies

Flag Multi-Source Alert RelationshipsMedium

Apptio

Optimize Dashboard Revenue Join QueryHard

AlphaSense

Audit CRM Data Integrity by TeamMedium