Incomplete number of rows in filtering by ORDER OF EXPRESSION

Q&A DQ Courses
, ,
#1

Hello,
I am having difficulties with the code below
Screen Link: (Learn data science with Python and R projects)

My Code:

SELECT customer_id, first_name, last_name, country,
  CASE
   WHEN country ="Canada" THEN "Canada"
    WHEN country ="USA" THEN "USA"
 END AS new_country
 FROM customer
 ORDER BY country desc
#2

What do you get with your answer? Can you tell why it doesn’t satisfy the instructions?