Fix a bug in default orderby calc. in compression

[nikkhils]

There was a "cute" typo in the query used for the calculation of default orderbys in the case of compression. Fixed that.

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 81.86%. Comparing base (59f50f2) to head (7ba7d49). Report is 224 commits behind head on main.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #7064 +/- ## ========================================== + Coverage 80.06% 81.86% +1.79% ========================================== Files 190 200 +10 Lines 37181 37298 +117 Branches 9450 9725 +275 ========================================== + Hits 29770 30533 +763 + Misses 2997 2857 -140 + Partials 4414 3908 -506 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[timescale-automation]

Automated backport to 2.15.x not done: cherry-pick failed.

Git status

HEAD detached at origin/2.15.x
You are currently cherry-picking commit 4e6e8e7e2.
  (fix conflicts and run "git cherry-pick --continue")
  (use "git cherry-pick --skip" to skip this patch)
  (use "git cherry-pick --abort" to cancel the cherry-pick operation)

Changes to be committed:
    new file:   .unreleased/fix_7064
    modified:   sql/compression_defaults.sql

Unmerged paths:
  (use "git add <file>..." to mark resolution)
    both modified:   tsl/test/expected/compression_defaults.out
    both modified:   tsl/test/sql/compression_defaults.sql

Job log