The sales table is modified, with the subpartition template set to eight. If you try to add a partition q1_2013, a new partition is created and consists of eight subpartitions. ALTER TABLE sales ADD ...