Challenge: Adoption Trend Analysis
Oppgave
Swipe to start coding
Write a SQL query to analyze how many users adopted the 'Upload' feature each month and what percentage of all users this represents.
- Group the adoption events for the 'Upload' feature by month.
- For each month, count the number of distinct users who used the 'Upload' feature.
- Calculate the adoption rate as the percentage of total users who adopted the feature each month.
- Return the start of the month, the number of users adopted, and the adoption rate percentage.
- Name the columns:
month_start,users_adopted, andadoption_rate_percent.
Løsning
Alt var klart?
Takk for tilbakemeldingene dine!
Seksjon 3. Kapittel 6
single
Spør AI
Spør AI
Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår
Fantastisk!
Completion rate forbedret til 4.17
Challenge: Adoption Trend Analysis
Sveip for å vise menyen
Oppgave
Swipe to start coding
Write a SQL query to analyze how many users adopted the 'Upload' feature each month and what percentage of all users this represents.
- Group the adoption events for the 'Upload' feature by month.
- For each month, count the number of distinct users who used the 'Upload' feature.
- Calculate the adoption rate as the percentage of total users who adopted the feature each month.
- Return the start of the month, the number of users adopted, and the adoption rate percentage.
- Name the columns:
month_start,users_adopted, andadoption_rate_percent.
Løsning
Alt var klart?
Takk for tilbakemeldingene dine!
Seksjon 3. Kapittel 6
single