Note that the BETWEEN operator includes both the upper and lower bound and therefore 5 is captured in both the 10 and 20 ranges.  Because of the way the CASE...

I feel for you, having to complete an exercise that isn't written in coherent sentences.  Goodness knows how you're supposed to understand what is required.  Putting that aside, though, do...

Use the DATEDIFF function to get the number of years, then use DATEADD to add that to the acquisition date, then use the DATEDIFF function again to get the number...

Not...

Here's some benefits I can see:
(1) If you want to install client tools on a server (which I think is a bad idea), you have to make a conscious...

Well, you decide whether you want to call it a requirement or an enhancement!  But yes, from 2016 SSMS is no longer bundled in the server product, but instead is...

PowerShell might be a good way to go here.  You can use the Invoke-SQL (I think that's what it's called) cmdlet and then pipe the results to the Format-Table cmdlet,...

The splitter function is indeed a table-valued function, but that doesn't mean you have to use the results in a table.  You can use it in a view if you...

This will work, but I suspect it's not what you're looking for.  So are you going to share the business rules with us, or wait for us to get bored...

You just need a splitter function.  Take a look at this.

John