Circle K Interview Question

Provide several tables, write sql suedo code