Two tables are given. In one table we have following columns

```
productid
product_title
priority
categoryid

```

and in second table we have

```
id
productid
color
selling_price
stock

```

Write a SQL query to select all products in category id 306 with pagination
Lets say Result set would have 1000+ such products so we want to paginate the
results. In a single request only 100 result need to be return