Table name "events"
user_id event_type Created 123 Flash Client log 25-Sep-16 127 Client Cyber log 25-Sep-16 123 Flash Client log 25-Sep-16 126 Flash Client log 25-Sep-16 185 Monitor log 25-Sep-16 146 Delete log 25-Sep-16 173 Flash Client log 26-Sep-16 183 Client Cyber log 26-Sep-16 193 Flash Client log 26-Sep-16 204 Monitor log 27-Sep-16 214 Delete log 27-Sep-16 225 Flash Client log 27-Sep-16
Expected result
Date Flash Clien 25-Sep-16 2 1 26-Sep-16 2 1 27-Sep-16 1 0
I was using below query but this wont show the required result.
SELECT COUNT (DISTINCT e.user_id) AS Flash, COUNT (DISTINCT et.user_id) AS Client, TO_CHAR (e.created) AS Date_created FROM events e INNER JOIN events et ON e.user_id = et.user_id WHERE e.created BETWEEN '25-SEP-15' AND '27-SEP-15' AND e.event_type = 'Flash Client log' AND et.event_type = 'Client Cyber log' GROUP BY TO_CHAR (e.created);
** I have uploaded image of the table as the data provided above is not aligned and I did not get insert table on this forum post