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?
> | ID | C_NO | DATE | AMOUT |
> | 2901 | 387 | "2003-10-09" | 23.00 |
> Obviously my table has many more entries.
> Thank you for any help.
> Richard Reina
> A people that values its privileges above its principles soon loses both.
> -Dwight D. Eisenhower.
SELECT C_NO FROM transactions_table
GROUP BY C_NO
HAVING COUNT(*) >= 4
AND COUNT(DATE > CURDATE() - INTERVAL 6 MONTH) = 0;