Word filtering
Imagine that we want to extract all the hybrid cars from our database. As you understand, doing it manually is a worthless job and has to be automated.
Surely it has already been implemented! To filter observations based on columns with text use WHERE statement. For example,
123SELECT * FROM audi_cars WHERE fueltype = 'Hybrid'
This query will return all the Hybrid cars.
Please note, that in that case, you have to use single quotes, not double!
Swipe to start coding
From audi_cars table extract only cars with Automatic transmission. Extract all the columns.
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.63Word filtering
Deslize para mostrar o menu
Imagine that we want to extract all the hybrid cars from our database. As you understand, doing it manually is a worthless job and has to be automated.
Surely it has already been implemented! To filter observations based on columns with text use WHERE statement. For example,
123SELECT * FROM audi_cars WHERE fueltype = 'Hybrid'
This query will return all the Hybrid cars.
Please note, that in that case, you have to use single quotes, not double!
Swipe to start coding
From audi_cars table extract only cars with Automatic transmission. Extract all the columns.
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
