SQL Query CASE Clause when > 180 days between TransactionDate for same MemberNumber probably a simple request but a rookie like me can’t seem to figure it out.