* group by "pivot-grouping" column

* update row order in tests

* fix tests

* fix assertion for successful response

* set up question without UI

* eslint

* random attempt to fix test before I set things up locally

* switch to other table 



* pr feedback [ci all]

* whoops! keyboard macro gone wrong [ci all]

* forgot to update a test [ci all]

* another test [ci all]

* put number in right place [ci all]

* Fixing up the errors on PostgreSQL (and other SQL databases)

Also ensuring tests run against drivers that support both expressions
and left-joins

[ci all]

* fixing test failures

* On Oracle and Snowflake, we need to add IDs *and* insert in smaller
batches

* Do not run these tests on Redshift

it takes more than 10 minutes just to insert the sample-dataset into
Redshift, so do not run these tests against Redshift. All other
databases in the `applicable-drivers` def are valid though.

Co-authored-by: Robert Roland <rob@metabase.com>