How to write a select that retrieves all merchants that have transactions all month but stopped on 2
Hello,
How to write a select that retrieves all merchants that have transactions in every day month but stopped having transacon on day 25/26/27 of one month in a specific time range.
The transaction table fields are:
merchant_name
merchant_id
transaction_date (Date)
transaction_month (number) -- like 20120100 , 20120200
How to write a select that retrieves all merchants that have transactions in every day month but stopped having transacon on day 25/26/27 of one month in a specific time range.
The transaction table fields are:
merchant_name
merchant_id
transaction_date (Date)
transaction_month (number) -- like 20120100 , 20120200
0