# MPP（A）

![left](./student-guide/diagram/31-MPP-01-02.png)

-------------------------------------------------------------
```
select count(*) from orders, products
where orders.pid = product.pid
and sub_str(orders.dic, 3) = ‘7c0’
and product.pct_date > ‘2021-09-30’
group by orders.state;
```