I have a table with books, there can be multiple copies of each book and I want to give each copy a copy number.

```
TABLE:
BOOK(book_pk, book_name, book_copy);

```

Basically each book\_pk will be unique, but if there are two rows with the same book\_name, one book\_copy should be set to 1, and the other set to 2.

```
TABLE ROWS:
1, AAA, 1
2, BBB, 1
3, AAA, 2
4, CCC, 1
5, BBB, 2

```

So I want to auto-increment the primary key and keep track of the copyNumber as I insert new tuples of the same book\_name.