Scotiabank interview question

SQL query questions Is VaR a coherent risk measure?