Your question is View All SQL Table Rows. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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.
cohort_id in ascending order so the output is deterministic.| 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 |