# Mpp (Continue...)


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