<commit_before>SELECT d.name, COUNT(*) AS hits
FROM domains d
LEFT OUTER JOIN hits h ON d.id = h.domain_id
GROUP BY d.name
ORDER BY hits DESC;<commit_msg>queries hits for just a certain time range<commit_after>SELECT d.name, COUNT(*) AS hits
FROM domains d
LEFT OUTER JOIN hits h ON d.id = h.domain_id
WHERE d.created_at <= '2015-01-01'
AND (h.created_at >= '2015-01-01' AND h.created_at <= '2015-02-01')
GROUP BY d.name
ORDER BY hits DESC;
{'fraction_non_alphanumeric': 0.11136363636363636, 'fraction_numerical': 0.05454545454545454, 'mean_word_length': 4.313253012048193, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 4, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3607652', 'n_tokens_mistral': 178, 'n_tokens_neox': 156, 'n_words': 61}