Get the maximum value of every hour in current date in mysql To get the…