Giesecke+Devrient interview question

They asked how to write specific queries in SQL.