[FUN] 쿼리 선호도 조사

• SQL을 배운 환경에 따라 쿼리 포맷 유형이 다르다.
• 이왕이면 같은 조직에 있는 팀원들이라면 서로 통일된 쿼리를 쓰면 좋겠지만 현실적으로는 맞추기 어렵다.
• 재미로 본인은 어느 성향의 유형을 쓰는지 체크해보면 재미있을거 같다.

항목별 유형

SELECT

    1. 
    SELECT
    	column1,
    	column2
    
    2. 
    SELECT 
    	column1
    	, column2
    
    3. 
    SELECT column1, column2
    
    
    4. 
    SELECT column1, 
           column2

WHERE

    1. 
    WHERE
    	a = true AND b = true
    
    2. 
    WHERE a = true
      AND b = true

JOIN

    1. 
    SELECT column1
    FROM TABLE_A
    LEFT JOIN TABLE_B ON TABLE_A.id = TABLE_B.id AND TABLE_A.id2 = TABLE_B.id2
    
    2. 
    SELECT column1
    FROM TABLE_A
    LEFT JOIN TABLE_B ON TABLE_A.id = TABLE_B.id 
    	AND TABLE_A.id2 = TABLE_B.id2
    
    3. 
    SELECT column1
    FROM TABLE_A
    LEFT JOIN TABLE_B 
    ON TABLE_A.id = TABLE_B.id
    AND TABLE_A.id2 = TABLE_B.id2
    
    4. 
    SELECT column1
    FROM TABLE_A
    LEFT JOIN TABLE_B 
    ON TABLE_A.id = TABLE_B.id
    	AND TABLE_A.id2 = TABLE_B.id2
    
    5. 
    SELECT column1
    FROM TABLE_A
    LEFT JOIN TABLE_B 
    ON 
    	TABLE_A.id = TABLE_B.id
    	AND TABLE_A.id2 = TABLE_B.id2

들여쓰기(indent)

    1.
    SELECT first_name AS fn
    FROM staff AS s1
    JOIN students AS s2
      ON s2.mentor_id = s1.staff_num
    
    2. 
    SELECT first_name AS fn
      FROM staff AS s1
      JOIN students AS s2
        ON s2.mentor_id = s1.staff_num
    
    3.
    SELECT first_name AS fn
    FROM   staff AS s1
    JOIN   students AS s2
      ON   s2.mentor_id = s1.staff_num