Interview Questions Interview Guides Experiences Mock Interviews

Interview Guides

Count Archive Center Documents by Status | Dataford Interview Questions

All questions/SQL & Data Manipulation

Count Archive Center Documents by Status

EasyJoinsGroup ByAggregations

Problem

You are given a table from an OpenText Archive Center reporting extract. Write a basic SQL query to return the number of documents for each document_status, considering only rows where retention_years is greater than 0. Sort the result by the document count in descending order.

Problem

You are given a table from an OpenText Archive Center reporting extract. Write a basic SQL query to return the number of documents for each document_status, considering only rows where retention_years is greater than 0. Sort the result by the document count in descending order.

Practice SQL

PostgreSQL

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

Up next

Veeva Systems

Filter Open Veeva Vault RecordsEasy

Bae Systems Usa

Count Open Defects by SeverityEasy

AlphaSense

Audit CRM Data Integrity by TeamMedium