Orange interview question

Oop and design pattern and advanced sql