Write a SQL query to get how many orders each seller had in each country in a table named seller_sales_information.
Table: seller_sales_infomation
+-----------+------------+-------------------+
| order_id | seller_id | order_country |
+-----------+------------+-------------------+
| c409 | a01 | CN |
| c372 | a01 | CN |
| c302 | a01 | CN |
| t121 | a01 | TH |
| s201 | b01 | SG |
| t242 | b01 | TH |
| c563 | c01 | CN |
| s507 | c01 | SG |
+----------+-----------+----------------------+
Your query should return the following output for the above table:
(for the seller who doesn't have an order in a certain country, output 0 in total_orders for that country)
+-----------+---------------+--------------+
| seller_id | order_country | total_orders |
+-----------+---------------+--------------+
| a01 | CN | 3 |
| a01 | SG | 0 |
| a01 | TH | 1 |
| b01 | CN | 0 |
| b01 | SG | 1 |
| b01 | TH | 1 |
| c01 | CN | 1 |
| c01 | SG | 1 |
| c01 | TH | 0 |
+-----------+---------------+--------------+
Please write a query to get desired output.
Table: seller_sales_infomation
+-----------+------------+-------------------+
| order_id | seller_id | order_country |
+-----------+------------+-------------------+
| c409 | a01 | CN |
| c372 | a01 | CN |
| c302 | a01 | CN |
| t121 | a01 | TH |
| s201 | b01 | SG |
| t242 | b01 | TH |
| c563 | c01 | CN |
| s507 | c01 | SG |
+----------+-----------+----------------------+
Your query should return the following output for the above table:
(for the seller who doesn't have an order in a certain country, output 0 in total_orders for that country)
+-----------+---------------+--------------+
| seller_id | order_country | total_orders |
+-----------+---------------+--------------+
| a01 | CN | 3 |
| a01 | SG | 0 |
| a01 | TH | 1 |
| b01 | CN | 0 |
| b01 | SG | 1 |
| b01 | TH | 1 |
| c01 | CN | 1 |
| c01 | SG | 1 |
| c01 | TH | 0 |
+-----------+---------------+--------------+
Please write a query to get desired output.