SQL: How to generate a result that updates columns based on the data?

Suppose we have a database (I'm using Snowflake) which keeps updating books based on which country it was released from.

Is there a way we can query it such that I get a total count in a different column without having to hardcode the countries in a for loop or something?

I'm expecting the output to be something that's grouped by date and has separate columns for each country count, something like this:

Is it possible to achieve this?

If I got this right, you can use the GROUP BY clause and the COUNT() function.

SELECT 
Date,
  COUNT(CASE WHEN Country = 'US' THEN 1 ELSE NULL END) AS US_Count,
  COUNT(CASE WHEN Country = 'CA' THEN 1 ELSE NULL END) AS CA_Count,
  COUNT(CASE WHEN Country = 'RU' THEN 1 ELSE NULL END) AS RU_Count
FROM 
  books_table
GROUP BY 
  Date;

https://www.datacamp.com/tutorial/count-sql-function