SCRIPT WRITING CONTEST: How to write a select that retrieves all merchants that have transactions in
How to write a select that retrieves all merchants that have transactions in every day month but
stopped having transacon since day 25/26/27 of one month till end of monthin a specific time range.
Retrieve all table columns that match.
the time range is from month 03/2009 - 08/2009
Match:
1. Merchants that have at least 1 transaction on day 01, at least 1 transaction on day 02, ..., at least 1 transaction on day 24,
and that have no txn starting on day 25 till end of month .
2. Merchants that have at least 1 transaction on day 01, at least 1 transaction on day 02, ..., at least 1 transaction on day 25,
and that have no txn starting on day 26 till end of month .
stopped having transacon since day 25/26/27 of one month till end of monthin a specific time range.
Retrieve all table columns that match.
the time range is from month 03/2009 - 08/2009
Match:
1. Merchants that have at least 1 transaction on day 01, at least 1 transaction on day 02, ..., at least 1 transaction on day 24,
and that have no txn starting on day 25 till end of month .
2. Merchants that have at least 1 transaction on day 01, at least 1 transaction on day 02, ..., at least 1 transaction on day 25,
and that have no txn starting on day 26 till end of month .
0