The results provided are incorrect because all the datetime values in the blockchain and in steemSQL are UTC based and you used GETDATE() in your queries instead of GETTUCDATE().
Not a very big deal but, depending on your timezone, you might get a shift of several hours.
yeah but with a 7 day period doesn’t change much