Meeshop interview question

2 SQL question in 30 min