by AskAI

Solutions:

Check these solutions from our community and artificial intelligence:
The solution above is optimal because it uses an inner join to find the records that have the same value for column C.