Database Reference
In-Depth Information
5. Redo the
SELECT
you constructed successfully at the end of the previous exer-
cise. Put what you assembled for the average time field into
DATE_FORMAT()
.
Change the format to display like this:
01 minute(s), 21 seconds
. When
finished, execute the SQL statement. For extra points, use a string function to re-
move the leading zero for minutes, and when they occur, for the seconds. Use the
IF()
function to set
minute
or
minutes
as needed,and
second
and
seconds
.