How to find the number of daily active users on an app for a given date range?

35
November 30, 2021, at 07:30 AM

I have this table in MySQL.

*user_id event_date_time Event

7494212 1535308430 Opened app

7494212 1535308433 Closed app

1475185 1535308444 Registered

6946725 1535308475 Opened app

6946725 1535308476 Made a purchase

6946725 1535308477 Closed app

This has millions of rows where event date time is in unix timestamp format.

I need to find the number of daily active users and monthly active users for the month of July-19. I tried the below mentioned query but it is not working in MySQL. Please help.

SELECT * FROM event_log; WHERE event_date_time BETWEEN 2014-07-01 00:00:00' AND '2019-07-31 23:59:59'
READ ALSO
Running the command node dist/index.js gives an error related to Typescript files in src folder

Running the command node dist/index.js gives an error related to Typescript files in src folder

I have a GraphQL and Apollo server https://githubcom/AdhamAH/Film-and-actors-list/tree/main/server

70
Android 11: How to access app specific files from Browser

Android 11: How to access app specific files from Browser

My app is creating some html files (reports) that user can open by using web browser

73
Intellij IDEA, java, maven, can´t use imported library [closed]

Intellij IDEA, java, maven, can´t use imported library [closed]

Want to improve this question? Add details and clarify the problem by editing this post

63