Aliasing with functions
Aliasing can be a lifesaver, especially as we start to do more complex SQL queries with multiple criteria. Aliases help you keep your code clean and readable. For example, if you want to find the MAX() value of several fields without aliasing, you'll end up with the result with several columns called max and no idea which is which. You can fix this with aliasing.
Now, it's over to you to clean up the following queries.
Latihan ini merupakan bagian dari kursus
Intermediate SQL
Latihan interaktif langsung praktik
Cobalah latihan ini dengan melengkapi kode contoh ini.
-- Calculate the title and duration_hours from films
SELECT title, ___
FROM films;