Go Concurrency, Postgres, and SQL

Goroutines questions, how to detect a race, how the data is saved in memory. Basic Postgres questions - types of keys, data types for primary keys, other. On a more challenging interview - explain an SQL statement, what it does. Some general kubernetes questions about pods, deployments,

Explain what the following SQL statement returns for the sample data, and identify which rows are excluded by the filter conditions.

Output

1. One row per matching account, with columns account_id, account_name, status, and created_at
2. Include only accounts that are active and created on or after 2024-01-01
3. Sort by created_at ascending, then account_id ascending
4. Rows with a NULL created_at are ignored