So I don't have much experience with SQL, and am trying to learn. An interview question I came across had this question. I'm trying to learn more SQL but maybe I'm missing a piece of info to solve this? Or maybe I'm approaching the problem wrong.

This is the question:

We have following two tables , below is their info: 

* POLICY (id as int, policy\_content as varchar2)
* POLICY\_VOTES (vote as boolean, policy\_id as int)

Write a single query that returns the policy\_id, number of yes(true) votes and number of no(false) votes with a row for each policy up for a vote stored

My first thought when approaching this was to use a WITH clause to get the policy\_ids and use an inner join to get the votes for yes and no but I can't find a way to make it work, which is what leads me to believe that there's another clause in SQL I'm not aware of or couldn't find that would make it easier. Either that or I'm thinking of the problem in the wrong way.