Using the following tables, write the SQL code which shows the total dollar value of transactions for products in the "Snack" category for each store in the city of "Jersey City". Include store$\_$id$,$ and the total dollar value of transactions in the query.

Hint: when joining three tables, you can write:

SELECT $...$ FROM table$1,$ table$2,$ table$3$ WHERE table$1.$key$1=$ table$2.$key$1$ AND table$1.$key$2=$ table$3.$key$2$

or

SELECT $...$ FROM table$1$ JOIN table$2$ ON table$1.$key$1=$ table$2.$key$1$ JOIN table$3$ ON table$1.$key$2=$ table$3.$key$2$