# MPP - Cont'd

![`smart`](MPP02_aa_002_20220512.png)

-------------------------------------------------------------
Assume a SQL statement like this:

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