SingleStore Interview Question

Optimize a query for a simple key-value store