Will you be able to solve this question in SQL?

Question

The marketing department wants to focus on the customers from North America first. Gets 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 ordered them by ID. Tip: Use the IN expression in the ORDER BY clause.

Answer 1

Select CustomerID, Lastname, Country from Customers
order by Country IN (' U', 'Canada'), CustomerID ;

this works....i even tried !!!

Answer 2

Select CustomerId,LastName,Country FROM Customer ORDER BY Country IN ('USA','CANADA') desc, CustomerId

Answer 3

select ID, Name, Country
from customers
order by Country in ('US', 'Canada'), ID

Answer 4

can i take u back guys... hw abt if the database contain other countries will they be listed aswel or only USA and Canada?

Answer 5

Select ID, Lastname, Country from Customers
order by Country IN ('USA', 'Canada'), ID;