te1BGJgp

1CREATE TABLE IF NOT EXISTS clicks(
2    id VARCHAR(255),
3    link VARCHAR(255),
4    clickDate INT
5    );
6	
7CREATE TABLE IF NOT EXISTS visits(
8    id VARCHAR(255),
9    ip INT,
10    browser VARCHAR(255)
11    );
12	
13SELECT
14    visits.ip,
15    count(visits.ip) as clicks_quantity,
16FROM visits
17INNER JOIN clicks
18ON visits.id=clicks.id
19WHERE clicks.clickDate BETWEEN 1 and 7
20GROUP BY
21    visits.ip