Im new with SQL.
I have 3 tables like below:

Table client: a list of clients with their first and last names, full address
Table Produit: a list of articles sent on the web site containing the name of the article, the country where it was manufactured, and its price
Table Actions: a list of all transactions done by clients with the time of the transactions.

**Output desired**

get the revenue generated by all clients where date is 2018 in each country, and ordered by the highest revenue first.