Greeting!!!
I reviewed your requirement,
I am Oracle Certified Data Scientist, Analyst Professional having over 5+ years experience in Database development covering multiple technologies like oracle, mysql,sql plsql.
I would like to work in this project,
I will continue to work with you till you satisfy with my work.
sample queries
SELECT PARTNER_FILE_ID,UPDATED UPDATED_DATE,EMAIL,ACCOUNT_NAME, ACCOUNT_OWNER, BUSINESS_PHONE, COMPANY, COMPANY_TYPE, CREATED, DESCRIPTION, DOOR_COUNT, FIRST_NAME, GROWTH_PLAN, GROWTH_TARGET_2020, LAST_NAME, LEAD_OWNER, LEAD_STATUS, MAILING_CITY, MAILING_COUNTRY, MAILING_STATE, MAILING_STREET, MAILING_ZIP, MOBILE_PHONE, PARTNER, SOURCE, OTHER_CITY, OTHER_STATE, OTHER_COUNTRY, OTHER_ZIP, OTHER_STREET, WEBSITE_1, WEBSITE_2, SURVEY_CONDUCTED, DEAL_NAME, CLOSING_DATE, CONTACT_TYPE, CONTACT_NAME, BDMS
FROM PM_DATA
WHERE updateddate BETWEEN '2020-09-01'
AND '2020-09-30'
AND partner_file_id <> 'P2'
order by partner_file_id asc, updateddate asc
;
Thanks
Kundlik R