Richard Reina wrote:
> Can someone help me write a query to tell me the customer numbers (C_NO) of
> those who've had more than 4 transactions but none in the last 6 months?
>
> transactions_table
> | ID | C_NO | DATE | AMOUT |
> | 2901 | 387 | "2003-10-09" | 23.00 |
>
> Obviously my table has many more entries.
>
> Thank you for any help.
>
> Sincerely,
>
> Richard Reina
>
> A people that values its privileges above its principles soon loses both.
> -Dwight D. Eisenhower.
Something like:
SELECT C_NO FROM transactions_table
GROUP BY C_NO
HAVING COUNT(*) >= 4
AND COUNT(DATE > CURDATE() - INTERVAL 6 MONTH) = 0;
Michael
