gistfile1.sql

use Bank;

SELECT client.client_id, account.account_no, COUNT(transactions.account_no)
FROM client, account, transactions
WHERE client.client_id = account.client_id AND
	  account.account_no = transactions.account_no
GROUP BY client.client_id, account.account_no
ORDER BY 3 DESC;