Skip to content

Instantly share code, notes, and snippets.

@ncouture
Created May 19, 2014 18:41
Show Gist options
  • Save ncouture/0b1126c28a2585773fbc to your computer and use it in GitHub Desktop.
Save ncouture/0b1126c28a2585773fbc to your computer and use it in GitHub Desktop.
mysql> select municipality, region, hydrographic_region from stations group by hydrographic_region asc;
+-------------------------+----------------------------------+------------------------------+
| municipality | region | hydrographic_region |
+-------------------------+----------------------------------+------------------------------+
| Rivière-Koksoak | Nord-du-Québec | Baie d'Ungava |
| Saint-Alphonse | Gaspésie--Îles-de-la-Madeleine | Baie des Chaleurs et Percé |
| Pikogan | Abitibi-Témiscamingue | Baies de Hannah et de Rupert |
| Baie-d'Hudson | Nord-du-Québec | Baies James et d'Hudson |
| Pointe-Claire | Montréal | Fleuve Saint-Laurent |
| Lantier | Laurentides | Outaouais et Montréal |
| Petit-Saguenay | Saguenay--Lac-Saint-Jean | Saguenay et lac Saint-Jean |
| Les Escoumins | Côte-Nord | Saint-Laurent nord-est |
| Saint-Michel-des-Saints | Lanaudière | Saint-Laurent nord-ouest |
| Rivière-Saint-Jean | Gaspésie--Îles-de-la-Madeleine | Saint-Laurent sud-est |
| Danville | Estrie | Saint-Laurent sud-ouest |
+-------------------------+----------------------------------+------------------------------+
11 rows in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment