MySQL Query: get new customers in a month

Question

I have millions of records in a table with the following columns:

id, item_id, customer_id, date

I want to find customer_idfor a specific month that are inserted for the first time in a table this month.

What is the best and easiest request for this.

thank

Answer 1

select customer_id , min(date) as min_date
from theTable
group by customer_id 
having min_date>=<the desired date>

Answer 2

try something like:

SELECT
date_format(date,"%M") month,group_concat(customer_id ORDER BY customer_id) customer_ids
FROM
<table_name>
GROUP BY month;

Answer 3

Something like this might be:

select distinct(id) from customer
where month(date)='Your_month'
order by date