<commit_before>SELECT total_bandwidth.bandwidth
	   total_storage.storage
	   total_bandwidth.bandwidth + total_storage.storage total_usage	
(SELECT 
	SUM(count_bandwidth) as bandwidth
FROM 
	kalturadw.dwh_hourly_partner_usage
WHERE
	{OBJ_ID_CLAUSE}
	AND
	date_id BETWEEN {FROM_DATE_ID} AND {TO_DATE_ID})) AS total_bandwidth,
(SELECT 
	MAX(aggr_count_mb) storage
FROM 
	kalturadw.dwh_hourly_partner_usage
WHERE
	{OBJ_ID_CLAUSE}
	AND
	bandwidth_source_id = 1
	AND 
	IF ({FROM_DATE_ID} = {TO_DATE_ID}, date_id = {FROM_DATE_ID},
	FLOOR(date_id/100) BETWEEN FLOOR({FROM_DATE_ID}/100) AND FLOOR({TO_DATE_ID}/100))) AS  total_storage
        <commit_msg>qnd: partner usage revamp<commit_after>SELECT total_bandwidth.bandwidth,
	   total_storage.storage,
	   total_bandwidth.bandwidth + total_storage.storage total_usage	
(SELECT 
	SUM(count_bandwidth_kb) as bandwidth
FROM 
	kalturadw.dwh_hourly_partner_usage
WHERE
	{OBJ_ID_CLAUSE}
	AND
	date_id BETWEEN {FROM_DATE_ID} AND {TO_DATE_ID})) AS total_bandwidth,
(SELECT 
	MAX(aggr_storage_mb) storage
FROM 
	kalturadw.dwh_hourly_partner_usage
WHERE
	{OBJ_ID_CLAUSE}
	AND
	bandwidth_source_id = 1
	AND 
	IF ({FROM_DATE_ID} = {TO_DATE_ID}, date_id = {FROM_DATE_ID},
	FLOOR(date_id/100) BETWEEN FLOOR({FROM_DATE_ID}/100) AND FLOOR({TO_DATE_ID}/100))) AS  total_storage
        
{'fraction_non_alphanumeric': 0.0844106463878327, 'fraction_numerical': 0.015209125475285171, 'mean_word_length': 5.854166666666667, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, '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': '2407659', 'n_tokens_mistral': 575, 'n_tokens_neox': 530, 'n_words': 93}