Skip to content

Latest commit

 

History

History
20 lines (13 loc) · 537 Bytes

Keep-Hydrated.md

File metadata and controls

20 lines (13 loc) · 537 Bytes

Nathan loves cycling.

Because Nathan knows it is important to stay hydrated, he drinks 0.5 litres of water per hour of cycling.

You get given the time in hours and you need to return the number of litres Nathan will drink, rounded to the smallest value.

For example:

time = 3 ----> litres = 1

time = 6.7---> litres = 3

time = 11.8--> litres = 5

You have to return 3 columns: id, hours and liters (not litres, it's a difference from the kata description)

SELECT *, FLOOR(hours*0.5) AS liters FROM cycling