AVEVA interview question

Some SQL queries