ORDER BY + IN statement?
<blockquote>
  <p>The marketing department wants to focus on the customers from Noth America first. Get the ID, last name and country of all customers. Build the list by bringing up the customers living in Canada and in the USA first, and finally order them by ID. <em>Tip:</em> use the IN expression in the ORDER BY clause.</p>
</blockquote>

<p>I've tried many times</p>

<pre><code>SELECT CustomerID, LastName, Country
FROM Customer
ORDER BY Country IN ('Canada', 'USA'), CustomerID
</code></pre>

<p>but it doesn't seem to work, as it takes the specified fields from all customers in the order they appear in the original table (which is also ordered by ID), even if I remove <code>CustomerID</code> from the <code>ORDER BY</code> clause, whithout caring to which country they belong to.</p>

<p>What should I do? I'm really new to SQL, and have no idea on how to fix this.</p>

<p>Edit: <code>WHERE</code> ins't suitable at all, as I need to take in consideration <em>all</em> customers, only making sure the Canadian and American ones appear at the top of the list.
Also I'm unsure statements like <code>UNION</code>, <code>AS</code>, <code>EXCEPT</code> and things like that are meant to be used, because the tutorial didn't go that deep already.</p>