Richard,
>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?
Something like this?
SELECT
c_no,
COUNT(c_no) AS cnt
FROM transactions_table
WHERE NOT EXISTS (
SELECT c_no
FROM transaction_table
WHERE DATEDIFF(NOW(),date)<=182
)
GROUP BY c_no
HAVING cnt > 4;
PB
-----
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.
>
>
>------------------------------------------------------------------------
>
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.1.371 / Virus Database: 267.14.13/221 - Release Date: 1/4/2006
>
>
Attachment: [text/html]
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.13/221 - Release Date: 1/4/2006
