Amazon Interview Question

In 10mins, write four SQL based solutions using a small dataset given.