Keep Hydrated!

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:

hours = 3 ----> liters = 1

hours = 6.7---> liters = 3

hours = 11.8--> liters = 5

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

 

 

 

Solution:

SELECT 
  id, hours, FLOOR(hours/2) AS liters 
FROM 
  cycling

 

 

Result:

id	hours	liters
1	4.46	2
2	58.07	29
3	99.42	49
4	96.11	48
5	92.6	46