SQLite Qurey to get weekly data's

You haven't supplied much to go on, but here's an example query:

SELECT COUNT(*),STRFTIME('%Y-%W',created,'unixepoch') AS creat 
FROM Files GROUP BY creat

This query counts the number of entries in the Files table, grouped by week.

SQLite date functions: http://www.sqlite.org/lang_datefunc.html[^]