Oracle MySQL: Appropriate Join/Connection For This Scenario? : I want to join two tables together which I have done

I also want to join them based on a condition, where a paricular column has a specific value, and I also have done this successfully. I used an inner join and a where clause so far.

However, for this result set, I want to further filter it by selecting ONLY the columns where a particular string appears more than once for a set of columns, eg;

employee_ID and CERTIFICATE

I'd like to group where employee_id has CERTIFICATE count > 2. This is after I have joined the tables together using a where clause.

I am perhaps thinking of using a subquery in my WHERE clause (which is the 3rd line that is also last)

Please helpt his is urgent, thanks! I am using Oracle.

For further clarification, I want to display only employees who have a certificate count greater than 2. By certificate, I am referencing a table with a string 'Certificate' under a column 'Skill'. In other words, select only columns where the string 'Certificate' appears TWICE for a particular employee ID

