Computer Science, asked by viswaboy50, 6 months ago

how to select query daily and monthly report?

Answers

Answered by VIVEKPARIDA

7

Answer:

I'm not sure if I understood your question correctly, but this gives you all the users created per day:

SELECT year(userCreated), month(userCreated), day(userCreated), count(*) FROM Users GROUP BY year(userCreated), month(userCreated

Previous Question

Next Question

Similar questions

English, 3 months ago

Imagine you are a tree.Write a story about your life...

History, 3 months ago

Ano ang karaniwang lahi ng mga tao sa Silangang Asya batay sa kanilang itsura?

English, 3 months ago

INSERT COMMAS AND CAPITAL LETTERS WHERE NECESSARY IN THE FOLLOWING SENTENCES- 1) a day when everything went wrong...

Physics, 6 months ago

If 3 resistances of 5 ohm each are connected in parallel, what will be their total resistance?

Math, 6 months ago

answer it pls pls question...

English, 9 months ago

Write 8 dialogues between a teacher and an old student of hers who meet after 5 years.

Social Sciences, 9 months ago

1. What are the essential things that we require...

Physics, 9 months ago

VING/QUIZ 5. Give one example of each of the following: a. Positive acceleration b. Negative acceleration c. Uniform acceleration d. Non-uniform acceleration e. The speed of an object first increases, remains constant for some time and then decreases. EET *** ** * **...