I have been working on a table in a database, which I need to show the clients that make at least one purchase every month. But until now I could not.
I leave the table and the query as it should appear, so they can help me.
PURCHASES table:
CLIENTES MES_COMPRA
-------- ----------------
ANGEL SEPTIEMBRE
BLANCA SEPTIEMBRE
DIEGO SEPTIEMBRE
FERNANDO OCTUBRE
DIEGO OCTUBRE
GABRIEL OCTUBRE
BLANCA OCTUBRE
Expected result of the query:
CLIENTES
--------
DIEGO
BLANCA