BigQuery: How to order table based on total for elements in one column, but the elements are not unique
I’ve been playing with BigQuery public data sets, i.e. bigquery-public-data.geo_international_ports.world_port_index. I’m selecting ‘country’ and ‘harbor_size’ columns and I’m calculating total count of country. I’m adding this as new row with value ‘ALL’ in column ‘harbor_size’. I want to sort on this total count but in a way, where all country elements stay together. Original ‘harbor_size’ […]