do they do coding in system design

[junior vortex]

I was once asked in a system design interview to write pseudocode for querying the DB and massaging the query results.

[pliant siren]

cool