# MPP (继续...)

![left](./student-guide/diagram/MPP02_aa_001_20220512.png)

-------------------------------------------------------------
我们先假设一条 SQL 语句如下:

```
Select count(*) from order, product
where order.pid = product.pid
and sub_str(order.dic, 3) = '7c0'
and product.pct_date > '2021-09-30'
group by order.state;
```