Complete an original backend job-test set in 50 minutes. The questions move from query correctness to schema design and reusable service interfaces. This is independent practice and doesn't claim to reproduce a vendor certification or an employer's private hiring test.
Read each output contract before writing SQL or choosing a response. Use the supplied evidence and keep missing values distinct from zeros, blanks and absent keys. For an operational scenario, select the option that satisfies every stated requirement rather than the one that sounds fastest.
The SQL tasks run on fresh fictional records and are checked again after those records change. You may use any equivalent query that produces the required result and preserves the stated database contract. The concurrency tasks use a clearly labeled session model. No question claims access to a live backup, a standby or a production connection pool.
Trim first, convert blank strings to NULL, then lowercase the remaining addresses.