• They are not too difficult in my opinion. Anyone with at least a year of SQL experience should be able to answer these more or less correct.

    (and I'm just a measly BI developer :-D)

    #3 might be a tad more difficult if you have never worked with triggers before. But then again, I almost never work with them and I immediately saw it cannot handle updates on multiple rows at the same time. 😉

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP