Amazon interview question

generic SQL questions on how to pull data from tables