I'm very new to SQL and I have gotten further than I thought.
Here is my query so far:
select META_DEVICE_MASTER."TYPE",
META_DEVICE_MASTER."FUNCTION",
META_DEVICE_MASTER."NETWORK_CATEGORY",
META_SOCKET_MASTER."CONNECTOR",
META_SOCKET_MASTER."MEDIUM",
META_SOCKET_MASTER."PORT_TYPE",
META_SOCKET_MASTER."SOCKET_NAME",
META_SOCKET_MASTER."SOCKET_NO",
META_SOCKET_MASTER."SOCKET_SIDE"
from META_SOCKET_MASTER
JOIN META_DEVICE_MASTER on META_DEVICE_MASTER.INTERNAL_ID = META_SOCKET_MASTER.DEVICE_MASTER_INTERNAL_ID
where type = '0-1375014-1' and socket_side ='A'
Can someone help me add this functionality?
I need to group by TYPE and count the total number of SOCKET_SIDE values for both
SOCKET_SIDE ='A' and SOCKET_SIDE ='B'
