SQL Homework – August 2020 – More DML Triggers

,

Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was unavoidable but I’m back and since it’s a bit late in the month (I generally try to post homework at the beginning of the month) let’s do something easy.

Write a select statement

Things you could include so you don’t decide this is too easy to bother with.

  • More than one table
    • INNER join
    • OUTER join
    • CROSS join
  • CTE
  • Subselect(s)
  • CROSS or OUTER APPLY
  • GROUP BY
  • HAVING
  • ORDER BY
  • UNION, EXCEPT, INTERSECT

 

I could go on but I want this to be fairly easy (but not too easy). I mean if you want to push yourself make it so the output is XML or JSON. Maybe throw in a GROUPING SET.

Also, please watch out for formatting and best practices. For example adding semicolons at the end of the command and not using SELECT *. Let’s pretend that whatever query you write is going to be looked at by a potential employer or the community at large.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

Share

Share

Rate