How many unique?
But what if we want to calculate the number of unique site visitors? Sounds like a combination of selecting unique and then counting...
Yes, that's the point! To calculate the number of unique observations over a certain column use COUNT(DISTINCT( ... )) statement. For example,
12SELECT COUNT(DISTINCT(user_id)) FROM visitors
This query will return a single value - the number of unique user_id in the visitors table.
Swipe to start coding
Count the number of different cars models in the audi_cars table.
Solução
Obrigado pelo seu feedback!
single
Pergunte à IA
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
Resumir este capítulo
Explicar o código em file
Explicar por que file não resolve a tarefa
Awesome!
Completion rate improved to 2.63How many unique?
Deslize para mostrar o menu
But what if we want to calculate the number of unique site visitors? Sounds like a combination of selecting unique and then counting...
Yes, that's the point! To calculate the number of unique observations over a certain column use COUNT(DISTINCT( ... )) statement. For example,
12SELECT COUNT(DISTINCT(user_id)) FROM visitors
This query will return a single value - the number of unique user_id in the visitors table.
Swipe to start coding
Count the number of different cars models in the audi_cars table.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
Awesome!
Completion rate improved to 2.63single
