Mistakes against query processing order
eSymphony wants to find out what composers don't have songs shorter than 1,000,000 milliseconds, and this only for tracks where the genre id equals 1.
You have received a query from someone that tried to solve this problem. They don't have the query processing order knowledge that you do and have made some mistakes. You are kind enough to help them out.
Bu egzersiz
Introduction to Oracle SQL
kursunun bir parçasıdırEgzersiz talimatları
- Adapt the query that was given to you to make it run without errors.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Adapt this query to make it run without errors
SELECT Composer, MIN(Milliseconds) AS MinSongLength
FROM Track
WHERE GenreId = 1 AND MIN(Milliseconds) > 1000000
GROUP BY Composer
ORDER BY MinSongLength