It’s really hard to understand how to combine
ROUND in one of the assignments. The task states
- Convert the
bytescolumn of the
tracktable to megabytes, and round the results to two decimal places. Alias the result as
This is my code, but I don’t know to to include the ROUND function.
SELECT (CAST(bytes AS FLOAT) / 1000000) AS megabytes FROM track;
It’s not very thought through to give such an “advanced” assignment without even giving examples how to combine these two functions.