Describe the key differences between SQL and NoSQL, and how you decide which one to use for a given problem.
For the hands-on portion, use the provided relational tables to demonstrate a case where SQL is appropriate. Return active engagements with at least two assigned members and their most recent update.
engagement_name, member_count, latest_update_status, and latest_update_date.engagement_name alphabetically.| Column | Type | Description |
|---|---|---|
| project_idPK | INT | Unique engagement identifier |
| project_name | VARCHAR(100) | Engagement name |
| status | VARCHAR(20) | Current engagement status |
| domain | VARCHAR(50) | Primary engagement domain |
| Column | Type | Description |
|---|---|---|
| member_idPK | INT | Unique member assignment identifier |
| project_id | INT | Referenced engagement identifier |
| member_name | VARCHAR(100) | Assigned member name |
| role | VARCHAR(50) | Member role on the engagement |
| Column | Type | Description |
|---|---|---|
| update_idPK | INT | Unique update identifier |
| project_id | INT | Referenced engagement identifier |
| update_date | DATE | Date of the update |
| update_status | VARCHAR(30) | Status recorded in the update |
| update_note | TEXT | Optional update note |