<blink>Our management is looking for a statistics to find out how many patients visited to a doctor for the first time.</blink>
<blink>I have employeemaster , registration and encounter tables</blink>
<blink>In encounter table we have visit date,doctored and registrationid</blink>
<blink>In registration table we have registrationid, registration date</blink>
<blink>In employeemaster we have doctorid, doctorname, joined date<,blink>
<blink>Report 1:The query will be encounterdate range it can be for days,month and year</blink>
<blink>REPORT 2: daily and monthly.<,blink>
<blink>This how I want to display the record</blink>