Circle K interview question

Provide several tables, write sql suedo code