Combining conditions
Often it's not enough to check for only one condition. What if we want to check if multiple conditions hold at the same time? Or at least one of them?
Conditions in SQL can be combined by using AND and OR statements within WHERE block. AND checks if all the conditions hold while OR checks if at least one of the conditions holds. For example, we can combine conditions from the two previous chapters: filter for hybrid cars with mileage less than 5000 miles.
123SELECT * FROM audi_cars WHERE fueltype = 'Hybrid' AND mileage < 5000
Also, we can extract only either cars with Automatic transmission either with an engine size less than 3 by using OR statement.
123SELECT * FROM audi_cars WHERE transmission = 'Automatic' OR enginesize < 3
Swipe to start coding
From audi_cars table extract only Diesel cars (fueltype column) with mileage less than 2000.
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.63Combining conditions
Deslize para mostrar o menu
Often it's not enough to check for only one condition. What if we want to check if multiple conditions hold at the same time? Or at least one of them?
Conditions in SQL can be combined by using AND and OR statements within WHERE block. AND checks if all the conditions hold while OR checks if at least one of the conditions holds. For example, we can combine conditions from the two previous chapters: filter for hybrid cars with mileage less than 5000 miles.
123SELECT * FROM audi_cars WHERE fueltype = 'Hybrid' AND mileage < 5000
Also, we can extract only either cars with Automatic transmission either with an engine size less than 3 by using OR statement.
123SELECT * FROM audi_cars WHERE transmission = 'Automatic' OR enginesize < 3
Swipe to start coding
From audi_cars table extract only Diesel cars (fueltype column) with mileage less than 2000.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
single
