Something

SELECT M_USER_COUNT_E_SUBSCRIPTN_ACT FROM m_website_statistics WHERE run_date > TRUNC(ADD_MONTHS(SYSDATE, -~Periods Elapsed~), 'MONTH') AND run_date < TRUNC(ADD_MONTHS(SYSDATE, -(~Periods Elapsed~-1)), 'MONTH');

SELECT m.m_avc_user_count_e_subcr_act FROM m_website_statistics m WHERE m.run_date > TRUNC(ADD_MONTHS(SYSDATE, -~Periods Elapsed~), 'MONTH') AND m.run_date < TRUNC(ADD_MONTHS(SYSDATE, -(~Periods Elapsed~-1)), 'MONTH');