I think it should be a simple thing to do in SQL, but I don't know much about it and my boss is out so I can't ask him:
suppose I have a "clients" table and an "orders" table. Every order belongs to a client. How do I write a query that finds certain users in the "clients" table and counts how many order each of these clients made in the "orders" table? For example, how many orders all the clients from South Africa made, when the country is in the "clients" table.
Thanks in advance.