QID interview question

SQL queries execution order and some of DAX queries