# 结果验证
参考[创建Starrocks数据库和表](https://support.huaweicloud.com/fsrtas-ctf/Flink_09.html)通过ECS上安装的mysql客户端登录到StarRocks，执行如下sql：
```
select * from ods_orders;
select * from mv_dwd_order_detail;
select * from mv_dws_channel_summary;
SELECT
    stat_date AS 统计日期,
    total_orders AS 总订单数,
    total_amount AS 总消费金额,
    online_orders AS 线上订单数量,
    offline_orders AS 线下订单数量,
    online_amount AS 线上消费金额,
    offline_amount AS 线下消费金额
FROM mv_ads_sales_dashboard;
```
以ADS层销售渠道统计实时看板视图为例：
图1ADS层用户画像视图mv_ads_sales_dashboard查询结果。
![](https://support.huaweicloud.com/fsrtas-ctf/zh-cn_image_0000002609901967.png)