SQL : Like %DL% / 여러개 JOIN / WHERE /

일단 정리해놓고

설명은 나중에 추가해놔야지

SELECT * FROM JUP_EX.tb_user_config where config_code like '%DL%'

SELECT OS_NAME, VM_UUID, VM_NAME, NUM_OF_SOCKET * CPU_PER_SOCKET AS cpu_core, TOTAL_DISK_SIZE_GB
FROM JDN.TB_VMS A JOIN JDN.VW_VMS B
ON A.vm_uuid = B.vm_uuid
JOIN PUBLIC.DWH_OSINFO C
ON A.os_id=C.os_id

SELECT IDX_VM_TASK_TYPE_TEMPLATE * NUM_OF_SOCKETS
 * CPU_PER_SOCKET AS cpu_core, MEMORY, SIZE_GB
FROM JUP_EX.VW_TEMPLATE A, JUP_EX.TB_VM_TASK_TYPE_TEMPLATE B
WHERE A.datacenter_uuid = cast(B.datacenter_uuid AS uuid) and DEL_FLAG='N'

SELECT p_group_id, group_name, user_id, user_name
FROM tb_groups A JOIN tb_group_users B
ON A.group_id= B.group_id
JOIN tb_users C 
ON B.user_uuid= C.user_uuid