# Mpp (Continue...)

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

------------------------------------------------------------
Let's first assume the following SQL statement:

```
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;
```