Amazon Interview Question

generic SQL questions on how to pull data from tables