NO-SNOW Fix tests which were lacking order by clause

[sfc-gh-pfus]

Description

NO-SNOW some tests started failing because select didn't have order by clause.

Checklist

• Created tests which fail without the change (if possible)
• Extended the README / documentation, if necessary

[codecov]

Codecov Report

All modified and coverable lines are covered by tests ✅

Project coverage is 82.25%. Comparing base (dda273b) to head (8f0bdc6).
Report is 1 commits behind head on master.

Additional details and impacted files

@@            Coverage Diff             @@
##           master    #1290      +/-   ##
==========================================
- Coverage   82.26%   82.25%   -0.02%     
==========================================
  Files          55       55              
  Lines       13569    13569              
==========================================
- Hits        11163    11161       -2     
- Misses       2406     2408       +2     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.