And just in case, do you happen to be changing SQL versions?   Perhaps from a 2012 or earlier to 2014 or later?   That would entail a change in the optimizer,...

What tool will actually run the query?   You don't have to do anything at all in your query if you use a reporting tool.   You can just format the value...

Lynn makes a good point.   If you actually want the number of products sold per minute, your data doesn't appear to justify that level of measurement.   Seems to me, that...

This kind of thing is extremely data dependent,   Could you ever have a single row that spans a year boundary (on or before 12/31/xxxx to on or after 1/1/xxxy, where...

Generally, you would want to use whatever tool makes the presentation of your results the easiest, which also means it's a solid and flexible tool that can do whatever you...

Try here:  https://docs.microsoft.com/en-us/sql/relational-databases/json/include-null-values-in-json-include-null-values-option?view=sql-server-2017