Below we have a code part for List partitioning for the supermarket departments:
PARTITION BY LIST (department_name) (
PARTITION p0 INSERT YOUR CODE ('Fruits', 'Vegetables'),
PARTITION p1 INSERT YOUR CODE ('Fish', 'Meet'),
PARTITION p2 INSERT YOUR CODE ('Dairy'),
PARTITION p3 INSERT YOUR CODE ('Sweets', 'Bakery'),
Type in the correct code to put into the 'INSERT YOUR CODE' line.