Walmart Global Tech interview question

SQL problems, about easy-medium difficulty.