Computer Science, asked by viswaboy50, 9 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

Math, 4 months ago

could someone ples help me...

Math, 4 months ago

7 + (2 + 6) 2 ÷ 4 ⋅ 1 over 2 whole to the power of 4...

Biology, 4 months ago

write a letter to G. E. B with regaed to the electricity bill which you have not received scince six months ...

Physics, 9 months ago

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

Math, 9 months ago

answer it pls pls question...

English, 1 year ago

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

Social Sciences, 1 year ago

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

Physics, 1 year 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 *** ** * **...