MySQL:
I need to present what is the volume of email requests we receive daily from upstream, how much percent we finally send, and a break of all the exclusions along with the error reason
TableA- This table contains all the input data received from upstream(columns: uniqueid,emailaddr,timestamp)
TableB- This table contains all the request payloads that has rejected in the initial phase itself due to data issues or validation error’s (columns: uniqueid,emailaddr,timestamp,errorreason)
TableC- This table contains all the campaign output or email sent data( column names same as tableA)
TableD- This table contains all the records rejected during campaign run along with reason(column names same as tableB)
select count(*) from tableA
— data we are getting from upstream
Likewise I write different queries..
But I need one query for entire using current timestamp and join
Vijju is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2