MyBatis SQL Query for Equipment Run Time and Status by Group

This is a SQL query written in MyBatis XML format. It selects various aggregated values for a given group of equipment, based on the specified time period. The query uses conditional logic and dynamic SQL to generate the appropriate grouping and ordering clauses based on the selected time period. The query retrieves data from the 'equ_run_day_value_iot' table and applies various filters based on the input parameters. The result is returned as a list of maps, where each map contains the aggregated values for a specific time period and equipment group.