Giesecke+Devrient Interview Question

They asked how to write specific queries in SQL.