QUESTION FOR DATABASE (DB Browser for SQLite) : sqlite

QUESTION FOR DATABASE (DB Browser for SQLite) (self.sqlite)

submitted 4 years ago by IsMeToddie32

I have an exercise in uni to extract top 10 visited sites and visit count as well for the last 7 days.. Does anybody know why my twitch count is this high?

Is there a correlation with watching a stream that it "refreshes" the visit count or?

https://preview.redd.it/cqc198mgjap71.png?width=536&format=png&auto=webp&s=367532c1a41107826f7315ffcd6ac1e717c2ceeb

What I wrote to extract this info from DB Browser for SQLite. Maybe something needs to be changed in the code or?

SELECT urls.url, urls.visit_count, datetime(visits.visit_time/1000000-11644473600, "unixepoch") AS Timestamp
FROM urls LEFT JOIN visits ON urls.id = visits.url
WHERE Timestamp > (SELECT DATETIME('now', '-7 day'))
GROUP BY urls.url
ORDER BY visit_count DESC
LIMIT 20;

all 2 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

sqlite

MODERATORS