summing inbound and outbound messages per orig/dest pair

Community Support
1

Basically I would like to sum total inbound messages and outbound messages for each ORIG and DEST pair
e.g. FRANCE  SWEDEN     1000202     202052525

q)meta tmp

c                     t f a
TRAFFIC_MONTH         s    
PEERING_CUSTOMER_ID   s    
ORIGINATION_NETWORK_ID s    
ORIGINATION_COUNTRY   s    
DESTINATION_NETWORK_ID s    
DESTINATION_COUNTRY   s    
OUTBOUND_MESSAGES     i    
INBOUND_MESSAGES      i 


q)select ORIGINATION_COUNTRY, DESTINATION_COUNTRY, OUTBOUND_MESSAGES, INBOUND_MESSAGES from tmp

ORIGINATION_COUNTRY DESTINATION_COUNTRY OUTBOUND_MESSAGES INBOUND_MESSAGES

--------------------------------------------------------------------------

SWEDEN INDIA 896 20

UNIT. ARAB EMIR THAILAND 0 66

VIETNAM INDIA 122717 144418

ZIMBABWE INDIA 10077 19811

ST KITTS/NEVIS INDIA 2 127

LUXEMBOURG INDIA 2053 2714

TAIWAN INDIA 145917 203791

INDIA BR VIRGIN ISL 219 0

INDIA INDIA 13480 0

INDIA INDIA 13480 0

INDIA RUSSIA 103 31

FIJI INDIA 166 639

SINGAPORE INDIA 0 8

INDIA U. K. 184 0

INDIA SWITZERLAND 0 223786

INDIA SWITZERLAND 0 223786

U. K. JAMAICA 0 2

U. K. JAMAICA 0 2

UNIT. ARAB EMIR HONDURAS 35 0

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 154 78

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

2

select sum OUTBOUND_MESSAGES, sum INBOUND_MESSAGES by ORIGIN,DESTINATION from table

On Sat, Jul 12, 2014 at 9:44 PM, ag <anuj.goyal@gmail.com> wrote:

Basically I would like to sum total inbound messages and outbound messages for each ORIG and DEST pair
e.g. FRANCE  SWEDEN     1000202     202052525

q)meta tmp

c                     t f a
TRAFFIC_MONTH         s    
PEERING_CUSTOMER_ID   s    
ORIGINATION_NETWORK_ID s    
ORIGINATION_COUNTRY   s    
DESTINATION_NETWORK_ID s    
DESTINATION_COUNTRY   s    
OUTBOUND_MESSAGES     i    
INBOUND_MESSAGES      i 


q)select ORIGINATION_COUNTRY, DESTINATION_COUNTRY, OUTBOUND_MESSAGES, INBOUND_MESSAGES from tmp

ORIGINATION_COUNTRY DESTINATION_COUNTRY OUTBOUND_MESSAGES INBOUND_MESSAGES

--------------------------------------------------------------------------

SWEDEN INDIA 896 20

UNIT. ARAB EMIR THAILAND 0 66

VIETNAM INDIA 122717 144418

ZIMBABWE INDIA 10077 19811

ST KITTS/NEVIS INDIA 2 127

LUXEMBOURG INDIA 2053 2714

TAIWAN INDIA 145917 203791

INDIA BR VIRGIN ISL 219 0

INDIA INDIA 13480 0

INDIA INDIA 13480 0

INDIA RUSSIA 103 31

FIJI INDIA 166 639

SINGAPORE INDIA 0 8

INDIA U. K. 184 0

INDIA SWITZERLAND 0 223786

INDIA SWITZERLAND 0 223786

U. K. JAMAICA 0 2

U. K. JAMAICA 0 2

UNIT. ARAB EMIR HONDURAS 35 0

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 154 78

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

FRANCE SWEDEN 77 39

–

Submitted via Google Groups