View All SQL Table Rows | Dataford Interview Questions

Revature's training operations team needs a complete view of all registered training cohorts. Write a PostgreSQL query that returns every row and column from the revature_training_cohorts table.

Requirements

Return all columns and all rows from the table.
Sort the results by cohort_id in ascending order so the output is deterministic.
Do not filter, aggregate, join, or limit the records.

Schema

revature_training_cohorts

Column	Type	Description
cohort_idPK	INTEGER	Unique training cohort identifier
cohort_name	VARCHAR(100)	Name of the Revature training cohort
delivery_mode	VARCHAR(30)	Training delivery format
status	VARCHAR(30)	Current cohort status
mentor_email	VARCHAR(150)	Email address of the assigned mentor

Your question is View All SQL Table Rows. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Revature's training operations team needs a complete view of all registered training cohorts. Write a PostgreSQL query that returns every row and column from the revature_training_cohorts table.

Requirements

Return all columns and all rows from the table.
Sort the results by cohort_id in ascending order so the output is deterministic.
Do not filter, aggregate, join, or limit the records.

Schema

revature_training_cohorts

Column	Type	Description
cohort_idPK	INTEGER	Unique training cohort identifier
cohort_name	VARCHAR(100)	Name of the Revature training cohort
delivery_mode	VARCHAR(30)	Training delivery format
status	VARCHAR(30)	Current cohort status
mentor_email	VARCHAR(150)	Email address of the assigned mentor

Your question is View All SQL Table Rows. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.