Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Apprendre The cheapest car | Sorting
SQL Basics

bookThe cheapest car

Remember the task from the third section, where you calculated the maximum price of a Diesel car? What if we want to see not only the price, but also what model, mileage, and other characteristics of this car?

One of the ways to solve it - is using nested queries, but this is not the topic for this course. Easier, you can order your table in descending order and limit the number of rows to 1! For example,


              
12345

            
SELECT *
FROM audi_cars
WHERE fueltype = 'Diesel'
ORDER BY price DESC
LIMIT 1
copy

This query will return all the Diesel cars, ordered by price in descending order with only 1 row! This is the car we were looking for.

Tâche

Swipe to start coding

From the audi_cars table extract the information for the cheapest car with Semi-Auto transmission.

Solution

Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 4. Chapitre 3
single

single

Demandez à l'IA

expand

Demandez à l'IA

ChatGPT

Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion

close

Awesome!

Completion rate improved to 2.63

bookThe cheapest car

Remember the task from the third section, where you calculated the maximum price of a Diesel car? What if we want to see not only the price, but also what model, mileage, and other characteristics of this car?

One of the ways to solve it - is using nested queries, but this is not the topic for this course. Easier, you can order your table in descending order and limit the number of rows to 1! For example,


              
12345

            
SELECT *
FROM audi_cars
WHERE fueltype = 'Diesel'
ORDER BY price DESC
LIMIT 1
copy

This query will return all the Diesel cars, ordered by price in descending order with only 1 row! This is the car we were looking for.

Tâche

Swipe to start coding

From the audi_cars table extract the information for the cheapest car with Semi-Auto transmission.

Solution

Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 4. Chapitre 3
single

single

close

Awesome!

Completion rate improved to 2.63

bookThe cheapest car

Glissez pour afficher le menu

Remember the task from the third section, where you calculated the maximum price of a Diesel car? What if we want to see not only the price, but also what model, mileage, and other characteristics of this car?

One of the ways to solve it - is using nested queries, but this is not the topic for this course. Easier, you can order your table in descending order and limit the number of rows to 1! For example,


              
12345

            
SELECT *
FROM audi_cars
WHERE fueltype = 'Diesel'
ORDER BY price DESC
LIMIT 1
copy

This query will return all the Diesel cars, ordered by price in descending order with only 1 row! This is the car we were looking for.

Tâche

Swipe to start coding

From the audi_cars table extract the information for the cheapest car with Semi-Auto transmission.

Solution

Switch to desktopPassez à un bureau pour une pratique réelleContinuez d'où vous êtes en utilisant l'une des options ci-dessous
Tout était clair ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

some-alt