# Grafana SQL 示範

SELECT 
    device_id,
    unit_id,
    $__timeGroupAlias(timestamp,$__interval),
    x_mean,
    x_sd,
    x_rms,
    x_crest,
    x_skewness,
    x_kurtosis,
    x_max,
    x_min,
    x_p2p,
    x_form,
    x_avgrms,
    x_avgsd,
    
    y_mean,
    y_sd,
    y_rms,
    y_crest,
    y_skewness,
    y_kurtosis,
    y_max,
    y_min,
    y_p2p,
    y_form,
    y_avgrms,
    y_avgsd,
    
    z_mean,
    z_sd,
    z_rms,
    z_crest,
    z_skewness,
    z_kurtosis,
    z_max,
    z_min,
    z_p2p,
    z_form,
    z_avgrms,
    z_avgsd
from tb_feature
order by $__timeGroup(timestamp,$__interval) desc
limit 100

###### tags: `Grafana` `tutorials`