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.
Solución
¡Gracias por tus comentarios!
single
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
Resumir este capítulo
Explicar el código en file
Explicar por qué file no resuelve la tarea
Awesome!
Completion rate improved to 2.63Combining conditions
Desliza para mostrar el menú
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.
Solución
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
single
