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

Зміст курсу

SQL Basics

SQL Basics

1. Selecting
2. Filtering
3. Aggregating
4. Sorting
5. Grouping
6. Practicing

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.

Завдання
test

Swipe to show code editor

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

Switch to desktopПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

Секція 4. Розділ 3
toggle bottom row

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.

Завдання
test

Swipe to show code editor

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

Switch to desktopПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

Секція 4. Розділ 3
toggle bottom row

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.

Завдання
test

Swipe to show code editor

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

Switch to desktopПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
Все було зрозуміло?

Як ми можемо покращити це?

Дякуємо за ваш відгук!

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.

Завдання
test

Swipe to show code editor

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

Switch to desktopПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
Секція 4. Розділ 3
Switch to desktopПерейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів
We're sorry to hear that something went wrong. What happened?
some-alt