Prepare > SQL > Advanced Select > New Companies

2023. 6. 27. 20:23ㆍHackerRank-My SQL

 

New Companies | HackerRank

Find total number of employees.

www.hackerrank.com

 

문제

Given the table schemas below, write a query to print the company_code, founder name, total number of lead managers, total number of senior managers, total number of managers, and total number of employees. Order your output by ascending company_code.

=> 모든 회사는 위 조직도를 따름. 회사코드, 창립자, 리드매니저 수, 숙달매니저 수, 매니저 수, 직원 수를 차례로 쿼리하라.

회사 코드로 정렬

 

 

 

 

코드

SELECT
CO.company_code,
CO.founder,
COUNT(DISTINCT(LM.lead_manager_code)),
COUNT(DISTINCT(SM.senior_manager_code)),
COUNT(DISTINCT(MA.manager_code)),
COUNT(DISTINCT(EM.employee_code))

FROM COMPANY AS CO
    LEFT JOIN LEAD_MANAGER AS LM ON CO.company_code = LM.company_code
        LEFT JOIN SENIOR_MANAGER AS SM ON LM.lead_manager_code = SM.lead_manager_code
            LEFT JOIN MANAGER AS MA ON SM.senior_manager_code = MA.senior_manager_code
                LEFT JOIN EMPLOYEE AS EM ON MA.manager_code = EM.manager_code
                
GROUP BY CO.company_code, CO.founder
ORDER BY CO.company_code

 

 

 

 

노트

# INPUT
SELECT
*

FROM COMPANY AS CO
    LEFT JOIN LEAD_MANAGER AS LM ON CO.company_code = LM.company_code
        LEFT JOIN SENIOR_MANAGER AS SM ON LM.lead_manager_code = SM.lead_manager_code
            LEFT JOIN MANAGER AS MA ON SM.senior_manager_code = MA.senior_manager_code
                LEFT JOIN EMPLOYEE AS EM ON MA.manager_code = EM.manager_code
  • 1: N 결합이 4번이나 반복 됐지만, 추후 DISTINCT() 함수를 쓸 예정이라 끼리끼리 묶어면 있다면 OK!
더보기

OUTPUT

C14 Maria LM14 C14 SM19 LM14 C14 M36 SM19 LM14 C14 E85 M36 SM19 LM14 C14 
C14 Maria LM14 C14 SM19 LM14 C14 M36 SM19 LM14 C14 E85 M36 SM19 LM14 C14 
C14 Maria LM14 C14 SM19 LM14 C14 M36 SM19 LM14 C14 E85 M36 SM19 LM14 C14 
C98 Christine LM98 C98 SM141 LM98 C98 M277 SM141 LM98 C98 E560 M277 SM141 LM98 C98 
C98 Christine LM98 C98 SM141 LM98 C98 M277 SM141 LM98 C98 E560 M277 SM141 LM98 C98 
C98 Christine LM98 C98 SM141 LM98 C98 M277 SM141 LM98 C98 E560 M277 SM141 LM98 C98 
C98 Christine LM98 C98 SM141 LM98 C98 M277 SM141 LM98 C98 E560 M277 SM141 LM98 C98 
C98 Christine LM98 C98 SM141 LM98 C98 M277 SM141 LM98 C98 E560 M277 SM141 LM98 C98 
C98 Christine LM98 C98 SM141 LM98 C98 M277 SM141 LM98 C98 E560 M277 SM141 LM98 C98 
C44 Lawrence LM44 C44 SM63 LM44 C44 M131 SM63 LM44 C44 E274 M131 SM63 LM44 C44 
C44 Lawrence LM44 C44 SM63 LM44 C44 M131 SM63 LM44 C44 E274 M131 SM63 LM44 C44 
C44 Lawrence LM44 C44 SM63 LM44 C44 M131 SM63 LM44 C44 E274 M131 SM63 LM44 C44 
C45 Marilyn LM45 C45 SM64 LM45 C45 M133 SM64 LM45 C45 E277 M133 SM64 LM45 C45 
C45 Marilyn LM45 C45 SM64 LM45 C45 M133 SM64 LM45 C45 E277 M133 SM64 LM45 C45 
C45 Marilyn LM45 C45 SM64 LM45 C45 M133 SM64 LM45 C45 E277 M133 SM64 LM45 C45 
C27 James LM27 C27 SM35 LM27 C27 M68 SM35 LM27 C27 E145 M68 SM35 LM27 C27 
C27 James LM27 C27 SM35 LM27 C27 M68 SM35 LM27 C27 E145 M68 SM35 LM27 C27 
C27 James LM27 C27 SM35 LM27 C27 M68 SM35 LM27 C27 E145 M68 SM35 LM27 C27 
C13 Pamela LM13 C13 SM17 LM13 C13 M29 SM17 LM13 C13 E68 M29 SM17 LM13 C13 
C13 Pamela LM13 C13 SM17 LM13 C13 M29 SM17 LM13 C13 E68 M29 SM17 LM13 C13 
C13 Pamela LM13 C13 SM17 LM13 C13 M29 SM17 LM13 C13 E68 M29 SM17 LM13 C13 
C13 Pamela LM13 C13 SM17 LM13 C13 M29 SM17 LM13 C13 E68 M29 SM17 LM13 C13 
C13 Pamela LM13 C13 SM17 LM13 C13 M29 SM17 LM13 C13 E68 M29 SM17 LM13 C13 
C13 Pamela LM13 C13 SM17 LM13 C13 M29 SM17 LM13 C13 E68 M29 SM17 LM13 C13 
C13 Pamela LM13 C13 SM17 LM13 C13 M29 SM17 LM13 C13 E68 M29 SM17 LM13 C13 
C13 Pamela LM13 C13 SM17 LM13 C13 M29 SM17 LM13 C13 E68 M29 SM17 LM13 C13 
C13 Pamela LM13 C13 SM17 LM13 C13 M29 SM17 LM13 C13 E68 M29 SM17 LM13 C13 
C13 Pamela LM13 C13 SM17 LM13 C13 M29 SM17 LM13 C13 E68 M29 SM17 LM13 C13 
C13 Pamela LM13 C13 SM17 LM13 C13 M29 SM17 LM13 C13 E68 M29 SM17 LM13 C13 
C13 Pamela LM13 C13 SM17 LM13 C13 M29 SM17 LM13 C13 E68 M29 SM17 LM13 C13 
C98 Christine LM98 C98 SM141 LM98 C98 M277 SM141 LM98 C98 E558 M277 SM141 LM98 C98 
C98 Christine LM98 C98 SM141 LM98 C98 M277 SM141 LM98 C98 E558 M277 SM141 LM98 C98 
C98 Christine LM98 C98 SM141 LM98 C98 M277 SM141 LM98 C98 E558 M277 SM141 LM98 C98 
C98 Christine LM98 C98 SM141 LM98 C98 M277 SM141 LM98 C98 E558 M277 SM141 LM98 C98 
C98 Christine LM98 C98 SM141 LM98 C98 M277 SM141 LM98 C98 E558 M277 SM141 LM98 C98 
C98 Christine LM98 C98 SM141 LM98 C98 M277 SM141 LM98 C98 E558 M277 SM141 LM98 C98 
C93 Jesse LM93 C93 SM135 LM93 C93 M265 SM135 LM93 C93 E536 M265 SM135 LM93 C93 
C93 Jesse LM93 C93 SM135 LM93 C93 M265 SM135 LM93 C93 E536 M265 SM135 LM93 C93 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E381 M187 SM93 LM65 C65 
C91 Diana LM91 C91 SM133 LM91 C91 M262 SM133 LM91 C91 E531 M262 SM133 LM91 C91 
C91 Diana LM91 C91 SM133 LM91 C91 M262 SM133 LM91 C91 E531 M262 SM133 LM91 C91 
C63 Dorothy LM63 C63 SM90 LM63 C63 M181 SM90 LM63 C63 E371 M181 SM90 LM63 C63 
C63 Dorothy LM63 C63 SM90 LM63 C63 M181 SM90 LM63 C63 E371 M181 SM90 LM63 C63 
C63 Dorothy LM63 C63 SM90 LM63 C63 M181 SM90 LM63 C63 E371 M181 SM90 LM63 C63 
C63 Dorothy LM63 C63 SM90 LM63 C63 M181 SM90 LM63 C63 E371 M181 SM90 LM63 C63 
C63 Dorothy LM63 C63 SM90 LM63 C63 M181 SM90 LM63 C63 E371 M181 SM90 LM63 C63 
C63 Dorothy LM63 C63 SM90 LM63 C63 M181 SM90 LM63 C63 E371 M181 SM90 LM63 C63 
C63 Dorothy LM63 C63 SM90 LM63 C63 M181 SM90 LM63 C63 E371 M181 SM90 LM63 C63 
C63 Dorothy LM63 C63 SM90 LM63 C63 M181 SM90 LM63 C63 E371 M181 SM90 LM63 C63 
C63 Dorothy LM63 C63 SM90 LM63 C63 M181 SM90 LM63 C63 E371 M181 SM90 LM63 C63 
C63 Dorothy LM63 C63 SM90 LM63 C63 M181 SM90 LM63 C63 E371 M181 SM90 LM63 C63 
C63 Dorothy LM63 C63 SM90 LM63 C63 M181 SM90 LM63 C63 E371 M181 SM90 LM63 C63 
C63 Dorothy LM63 C63 SM90 LM63 C63 M181 SM90 LM63 C63 E371 M181 SM90 LM63 C63 
C8 Todd LM8 C8 SM11 LM8 C8 M16 SM11 LM8 C8 E40 M16 SM11 LM8 C8 
C8 Todd LM8 C8 SM11 LM8 C8 M16 SM11 LM8 C8 E40 M16 SM11 LM8 C8 
C8 Todd LM8 C8 SM11 LM8 C8 M16 SM11 LM8 C8 E40 M16 SM11 LM8 C8 
C83 Alan LM83 C83 SM121 LM83 C83 M241 SM121 LM83 C83 E494 M241 SM121 LM83 C83 
C83 Alan LM83 C83 SM121 LM83 C83 M241 SM121 LM83 C83 E494 M241 SM121 LM83 C83 
C83 Alan LM83 C83 SM121 LM83 C83 M241 SM121 LM83 C83 E494 M241 SM121 LM83 C83 
C83 Alan LM83 C83 SM121 LM83 C83 M241 SM121 LM83 C83 E494 M241 SM121 LM83 C83 
C27 James LM27 C27 SM35 LM27 C27 M68 SM35 LM27 C27 E146 M68 SM35 LM27 C27 
C27 James LM27 C27 SM35 LM27 C27 M68 SM35 LM27 C27 E146 M68 SM35 LM27 C27 
C27 James LM27 C27 SM35 LM27 C27 M68 SM35 LM27 C27 E146 M68 SM35 LM27 C27 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C71 Ann LM71 C71 SM103 LM71 C71 M206 SM103 LM71 C71 E422 M206 SM103 LM71 C71 
C99 Lillian LM99 C99 SM142 LM99 C99 M279 SM142 LM99 C99 E564 M279 SM142 LM99 C99 
C99 Lillian LM99 C99 SM142 LM99 C99 M279 SM142 LM99 C99 E564 M279 SM142 LM99 C99 
C99 Lillian LM99 C99 SM142 LM99 C99 M279 SM142 LM99 C99 E564 M279 SM142 LM99 C99 
C99 Lillian LM99 C99 SM142 LM99 C99 M279 SM142 LM99 C99 E564 M279 SM142 LM99 C99 
C99 Lillian LM99 C99 SM142 LM99 C99 M279 SM142 LM99 C99 E564 M279 SM142 LM99 C99 
C99 Lillian LM99 C99 SM142 LM99 C99 M279 SM142 LM99 C99 E564 M279 SM142 LM99 C99 
C44 Lawrence LM44 C44 SM63 LM44 C44 M132 SM63 LM44 C44 E275 M132 SM63 LM44 C44 
C44 Lawrence LM44 C44 SM63 LM44 C44 M132 SM63 LM44 C44 E275 M132 SM63 LM44 C44 
C44 Lawrence LM44 C44 SM63 LM44 C44 M132 SM63 LM44 C44 E275 M132 SM63 LM44 C44 
C87 Robin LM87 C87 SM127 LM87 C87 M252 SM127 LM87 C87 E516 M252 SM127 LM87 C87 
C87 Robin LM87 C87 SM127 LM87 C87 M252 SM127 LM87 C87 E516 M252 SM127 LM87 C87 
C87 Robin LM87 C87 SM127 LM87 C87 M252 SM127 LM87 C87 E516 M252 SM127 LM87 C87 
C87 Robin LM87 C87 SM127 LM87 C87 M252 SM127 LM87 C87 E516 M252 SM127 LM87 C87 
C87 Robin LM87 C87 SM127 LM87 C87 M252 SM127 LM87 C87 E516 M252 SM127 LM87 C87 
C87 Robin LM87 C87 SM127 LM87 C87 M252 SM127 LM87 C87 E516 M252 SM127 LM87 C87 
C87 Robin LM87 C87 SM127 LM87 C87 M252 SM127 LM87 C87 E516 M252 SM127 LM87 C87 
C87 Robin LM87 C87 SM127 LM87 C87 M252 SM127 LM87 C87 E516 M252 SM127 LM87 C87 
C78 Nancy LM78 C78 SM115 LM78 C78 M230 SM115 LM78 C78 E474 M230 SM115 LM78 C78 
C78 Nancy LM78 C78 SM115 LM78 C78 M230 SM115 LM78 C78 E474 M230 SM115 LM78 C78 
C78 Nancy LM78 C78 SM115 LM78 C78 M230 SM115 LM78 C78 E474 M230 SM115 LM78 C78 
C78 Nancy LM78 C78 SM115 LM78 C78 M230 SM115 LM78 C78 E474 M230 SM115 LM78 C78 
C78 Nancy LM78 C78 SM115 LM78 C78 M230 SM115 LM78 C78 E474 M230 SM115 LM78 C78 
C78 Nancy LM78 C78 SM115 LM78 C78 M230 SM115 LM78 C78 E474 M230 SM115 LM78 C78 
C78 Nancy LM78 C78 SM115 LM78 C78 M230 SM115 LM78 C78 E474 M230 SM115 LM78 C78 
C78 Nancy LM78 C78 SM115 LM78 C78 M230 SM115 LM78 C78 E474 M230 SM115 LM78 C78 
C78 Nancy LM78 C78 SM115 LM78 C78 M230 SM115 LM78 C78 E474 M230 SM115 LM78 C78 
C78 Nancy LM78 C78 SM115 LM78 C78 M230 SM115 LM78 C78 E474 M230 SM115 LM78 C78 
C78 Nancy LM78 C78 SM115 LM78 C78 M230 SM115 LM78 C78 E474 M230 SM115 LM78 C78 
C78 Nancy LM78 C78 SM115 LM78 C78 M230 SM115 LM78 C78 E474 M230 SM115 LM78 C78 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C51 Timothy LM51 C51 SM73 LM51 C51 M151 SM73 LM51 C51 E316 M151 SM73 LM51 C51 
C51 Timothy LM51 C51 SM73 LM51 C51 M151 SM73 LM51 C51 E316 M151 SM73 LM51 C51 
C51 Timothy LM51 C51 SM73 LM51 C51 M151 SM73 LM51 C51 E316 M151 SM73 LM51 C51 
C51 Timothy LM51 C51 SM73 LM51 C51 M151 SM73 LM51 C51 E316 M151 SM73 LM51 C51 
C51 Timothy LM51 C51 SM73 LM51 C51 M151 SM73 LM51 C51 E316 M151 SM73 LM51 C51 
C51 Timothy LM51 C51 SM73 LM51 C51 M151 SM73 LM51 C51 E316 M151 SM73 LM51 C51 
C51 Timothy LM51 C51 SM73 LM51 C51 M151 SM73 LM51 C51 E316 M151 SM73 LM51 C51 
C51 Timothy LM51 C51 SM73 LM51 C51 M151 SM73 LM51 C51 E316 M151 SM73 LM51 C51 
C51 Timothy LM51 C51 SM73 LM51 C51 M151 SM73 LM51 C51 E316 M151 SM73 LM51 C51 
C51 Timothy LM51 C51 SM73 LM51 C51 M151 SM73 LM51 C51 E316 M151 SM73 LM51 C51 
C51 Timothy LM51 C51 SM73 LM51 C51 M151 SM73 LM51 C51 E316 M151 SM73 LM51 C51 
C51 Timothy LM51 C51 SM73 LM51 C51 M151 SM73 LM51 C51 E316 M151 SM73 LM51 C51 
C58 Paul LM58 C58 SM82 LM58 C58 M166 SM82 LM58 C58 E343 M166 SM82 LM58 C58 
C58 Paul LM58 C58 SM82 LM58 C58 M166 SM82 LM58 C58 E343 M166 SM82 LM58 C58 
C58 Paul LM58 C58 SM82 LM58 C58 M166 SM82 LM58 C58 E343 M166 SM82 LM58 C58 
C58 Paul LM58 C58 SM82 LM58 C58 M166 SM82 LM58 C58 E343 M166 SM82 LM58 C58 
C58 Paul LM58 C58 SM82 LM58 C58 M166 SM82 LM58 C58 E343 M166 SM82 LM58 C58 
C58 Paul LM58 C58 SM82 LM58 C58 M166 SM82 LM58 C58 E343 M166 SM82 LM58 C58 
C58 Paul LM58 C58 SM82 LM58 C58 M166 SM82 LM58 C58 E343 M166 SM82 LM58 C58 
C58 Paul LM58 C58 SM82 LM58 C58 M166 SM82 LM58 C58 E343 M166 SM82 LM58 C58 
C13 Pamela LM13 C13 SM18 LM13 C13 M32 SM18 LM13 C13 E77 M32 SM18 LM13 C13 
C13 Pamela LM13 C13 SM18 LM13 C13 M32 SM18 LM13 C13 E77 M32 SM18 LM13 C13 
C13 Pamela LM13 C13 SM18 LM13 C13 M32 SM18 LM13 C13 E77 M32 SM18 LM13 C13 
C13 Pamela LM13 C13 SM18 LM13 C13 M32 SM18 LM13 C13 E77 M32 SM18 LM13 C13 
C13 Pamela LM13 C13 SM18 LM13 C13 M32 SM18 LM13 C13 E77 M32 SM18 LM13 C13 
C13 Pamela LM13 C13 SM18 LM13 C13 M32 SM18 LM13 C13 E77 M32 SM18 LM13 C13 
C13 Pamela LM13 C13 SM18 LM13 C13 M32 SM18 LM13 C13 E77 M32 SM18 LM13 C13 
C13 Pamela LM13 C13 SM18 LM13 C13 M32 SM18 LM13 C13 E77 M32 SM18 LM13 C13 
C13 Pamela LM13 C13 SM18 LM13 C13 M32 SM18 LM13 C13 E77 M32 SM18 LM13 C13 
C13 Pamela LM13 C13 SM18 LM13 C13 M32 SM18 LM13 C13 E77 M32 SM18 LM13 C13 
C13 Pamela LM13 C13 SM18 LM13 C13 M32 SM18 LM13 C13 E77 M32 SM18 LM13 C13 
C13 Pamela LM13 C13 SM18 LM13 C13 M32 SM18 LM13 C13 E77 M32 SM18 LM13 C13 
C22 Harry LM22 C22 SM30 LM22 C22 M59 SM30 LM22 C22 E124 M59 SM30 LM22 C22 
C22 Harry LM22 C22 SM30 LM22 C22 M59 SM30 LM22 C22 E124 M59 SM30 LM22 C22 
C22 Harry LM22 C22 SM30 LM22 C22 M59 SM30 LM22 C22 E124 M59 SM30 LM22 C22 
C22 Harry LM22 C22 SM30 LM22 C22 M59 SM30 LM22 C22 E124 M59 SM30 LM22 C22 
C22 Harry LM22 C22 SM30 LM22 C22 M59 SM30 LM22 C22 E124 M59 SM30 LM22 C22 
C22 Harry LM22 C22 SM30 LM22 C22 M59 SM30 LM22 C22 E124 M59 SM30 LM22 C22 
C94 Joyce LM94 C94 SM137 LM94 C94 M270 SM137 LM94 C94 E549 M270 SM137 LM94 C94 
C94 Joyce LM94 C94 SM137 LM94 C94 M270 SM137 LM94 C94 E549 M270 SM137 LM94 C94 
C94 Joyce LM94 C94 SM137 LM94 C94 M270 SM137 LM94 C94 E549 M270 SM137 LM94 C94 
C94 Joyce LM94 C94 SM137 LM94 C94 M270 SM137 LM94 C94 E549 M270 SM137 LM94 C94 
C94 Joyce LM94 C94 SM137 LM94 C94 M270 SM137 LM94 C94 E549 M270 SM137 LM94 C94 
C94 Joyce LM94 C94 SM137 LM94 C94 M270 SM137 LM94 C94 E549 M270 SM137 LM94 C94 
C94 Joyce LM94 C94 SM137 LM94 C94 M270 SM137 LM94 C94 E549 M270 SM137 LM94 C94 
C94 Joyce LM94 C94 SM137 LM94 C94 M270 SM137 LM94 C94 E549 M270 SM137 LM94 C94 
C94 Joyce LM94 C94 SM137 LM94 C94 M270 SM137 LM94 C94 E549 M270 SM137 LM94 C94 
C94 Joyce LM94 C94 SM137 LM94 C94 M270 SM137 LM94 C94 E549 M270 SM137 LM94 C94 
C94 Joyce LM94 C94 SM137 LM94 C94 M270 SM137 LM94 C94 E549 M270 SM137 LM94 C94 
C94 Joyce LM94 C94 SM137 LM94 C94 M270 SM137 LM94 C94 E549 M270 SM137 LM94 C94 
C81 Benjamin LM81 C81 SM118 LM81 C81 M234 SM118 LM81 C81 E482 M234 SM118 LM81 C81 
C81 Benjamin LM81 C81 SM118 LM81 C81 M234 SM118 LM81 C81 E482 M234 SM118 LM81 C81 
C81 Benjamin LM81 C81 SM118 LM81 C81 M234 SM118 LM81 C81 E482 M234 SM118 LM81 C81 
C81 Benjamin LM81 C81 SM118 LM81 C81 M234 SM118 LM81 C81 E482 M234 SM118 LM81 C81 
C81 Benjamin LM81 C81 SM118 LM81 C81 M234 SM118 LM81 C81 E482 M234 SM118 LM81 C81 
C81 Benjamin LM81 C81 SM118 LM81 C81 M234 SM118 LM81 C81 E482 M234 SM118 LM81 C81 
C81 Benjamin LM81 C81 SM118 LM81 C81 M234 SM118 LM81 C81 E482 M234 SM118 LM81 C81 
C81 Benjamin LM81 C81 SM118 LM81 C81 M234 SM118 LM81 C81 E482 M234 SM118 LM81 C81 
C81 Benjamin LM81 C81 SM118 LM81 C81 M234 SM118 LM81 C81 E482 M234 SM118 LM81 C81 
C6 Bonnie LM6 C6 SM9 LM6 C6 M13 SM9 LM6 C6 E32 M13 SM9 LM6 C6 
C6 Bonnie LM6 C6 SM9 LM6 C6 M13 SM9 LM6 C6 E32 M13 SM9 LM6 C6 
C6 Bonnie LM6 C6 SM9 LM6 C6 M13 SM9 LM6 C6 E32 M13 SM9 LM6 C6 
C6 Bonnie LM6 C6 SM9 LM6 C6 M13 SM9 LM6 C6 E32 M13 SM9 LM6 C6 
C6 Bonnie LM6 C6 SM9 LM6 C6 M13 SM9 LM6 C6 E32 M13 SM9 LM6 C6 
C6 Bonnie LM6 C6 SM9 LM6 C6 M13 SM9 LM6 C6 E32 M13 SM9 LM6 C6 
C70 Brandon LM70 C70 SM101 LM70 C70 M202 SM101 LM70 C70 E415 M202 SM101 LM70 C70 
C70 Brandon LM70 C70 SM101 LM70 C70 M202 SM101 LM70 C70 E415 M202 SM101 LM70 C70 
C70 Brandon LM70 C70 SM101 LM70 C70 M202 SM101 LM70 C70 E415 M202 SM101 LM70 C70 
C70 Brandon LM70 C70 SM101 LM70 C70 M202 SM101 LM70 C70 E415 M202 SM101 LM70 C70 
C70 Brandon LM70 C70 SM101 LM70 C70 M202 SM101 LM70 C70 E415 M202 SM101 LM70 C70 
C70 Brandon LM70 C70 SM101 LM70 C70 M202 SM101 LM70 C70 E415 M202 SM101 LM70 C70 
C70 Brandon LM70 C70 SM101 LM70 C70 M202 SM101 LM70 C70 E415 M202 SM101 LM70 C70 
C70 Brandon LM70 C70 SM101 LM70 C70 M202 SM101 LM70 C70 E415 M202 SM101 LM70 C70 
C70 Brandon LM70 C70 SM101 LM70 C70 M202 SM101 LM70 C70 E415 M202 SM101 LM70 C70 
C70 Brandon LM70 C70 SM101 LM70 C70 M202 SM101 LM70 C70 E415 M202 SM101 LM70 C70 
C70 Brandon LM70 C70 SM101 LM70 C70 M202 SM101 LM70 C70 E415 M202 SM101 LM70 C70 
C70 Brandon LM70 C70 SM101 LM70 C70 M202 SM101 LM70 C70 E415 M202 SM101 LM70 C70 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C33 David LM33 C33 SM44 LM33 C33 M85 SM44 LM33 C33 E183 M85 SM44 LM33 C33 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C28 Kelly LM28 C28 SM36 LM28 C28 M70 SM36 LM28 C28 E150 M70 SM36 LM28 C28 
C19 Paula LM19 C19 SM27 LM19 C19 M51 SM27 LM19 C19 E110 M51 SM27 LM19 C19 
C19 Paula LM19 C19 SM27 LM19 C19 M51 SM27 LM19 C19 E110 M51 SM27 LM19 C19 
C19 Paula LM19 C19 SM27 LM19 C19 M51 SM27 LM19 C19 E110 M51 SM27 LM19 C19 
C19 Paula LM19 C19 SM27 LM19 C19 M51 SM27 LM19 C19 E110 M51 SM27 LM19 C19 
C19 Paula LM19 C19 SM27 LM19 C19 M51 SM27 LM19 C19 E110 M51 SM27 LM19 C19 
C19 Paula LM19 C19 SM27 LM19 C19 M51 SM27 LM19 C19 E110 M51 SM27 LM19 C19 
C19 Paula LM19 C19 SM27 LM19 C19 M51 SM27 LM19 C19 E110 M51 SM27 LM19 C19 
C19 Paula LM19 C19 SM27 LM19 C19 M51 SM27 LM19 C19 E110 M51 SM27 LM19 C19 
C19 Paula LM19 C19 SM27 LM19 C19 M51 SM27 LM19 C19 E110 M51 SM27 LM19 C19 
C19 Paula LM19 C19 SM27 LM19 C19 M51 SM27 LM19 C19 E110 M51 SM27 LM19 C19 
C19 Paula LM19 C19 SM27 LM19 C19 M51 SM27 LM19 C19 E110 M51 SM27 LM19 C19 
C19 Paula LM19 C19 SM27 LM19 C19 M51 SM27 LM19 C19 E110 M51 SM27 LM19 C19 
C9 Joe LM9 C9 SM12 LM9 C9 M17 SM12 LM9 C9 E43 M17 SM12 LM9 C9 
C9 Joe LM9 C9 SM12 LM9 C9 M17 SM12 LM9 C9 E43 M17 SM12 LM9 C9 
C9 Joe LM9 C9 SM12 LM9 C9 M17 SM12 LM9 C9 E43 M17 SM12 LM9 C9 
C9 Joe LM9 C9 SM12 LM9 C9 M17 SM12 LM9 C9 E43 M17 SM12 LM9 C9 
C9 Joe LM9 C9 SM12 LM9 C9 M17 SM12 LM9 C9 E43 M17 SM12 LM9 C9 
C9 Joe LM9 C9 SM12 LM9 C9 M17 SM12 LM9 C9 E43 M17 SM12 LM9 C9 
C71 Ann LM71 C71 SM102 LM71 C71 M204 SM102 LM71 C71 E419 M204 SM102 LM71 C71 
C71 Ann LM71 C71 SM102 LM71 C71 M204 SM102 LM71 C71 E419 M204 SM102 LM71 C71 
C71 Ann LM71 C71 SM102 LM71 C71 M204 SM102 LM71 C71 E419 M204 SM102 LM71 C71 
C71 Ann LM71 C71 SM102 LM71 C71 M204 SM102 LM71 C71 E419 M204 SM102 LM71 C71 
C5 Kimberly LM5 C5 SM7 LM5 C5 M10 SM7 LM5 C5 E25 M10 SM7 LM5 C5 
C5 Kimberly LM5 C5 SM7 LM5 C5 M10 SM7 LM5 C5 E25 M10 SM7 LM5 C5 
C5 Kimberly LM5 C5 SM7 LM5 C5 M10 SM7 LM5 C5 E25 M10 SM7 LM5 C5 
C5 Kimberly LM5 C5 SM7 LM5 C5 M10 SM7 LM5 C5 E25 M10 SM7 LM5 C5 
C5 Kimberly LM5 C5 SM7 LM5 C5 M10 SM7 LM5 C5 E25 M10 SM7 LM5 C5 
C5 Kimberly LM5 C5 SM7 LM5 C5 M10 SM7 LM5 C5 E25 M10 SM7 LM5 C5 
C44 Lawrence LM44 C44 SM63 LM44 C44 M130 SM63 LM44 C44 E273 M130 SM63 LM44 C44 
C44 Lawrence LM44 C44 SM63 LM44 C44 M130 SM63 LM44 C44 E273 M130 SM63 LM44 C44 
C44 Lawrence LM44 C44 SM63 LM44 C44 M130 SM63 LM44 C44 E273 M130 SM63 LM44 C44 
C44 Lawrence LM44 C44 SM63 LM44 C44 M130 SM63 LM44 C44 E273 M130 SM63 LM44 C44 
C44 Lawrence LM44 C44 SM63 LM44 C44 M130 SM63 LM44 C44 E273 M130 SM63 LM44 C44 
C44 Lawrence LM44 C44 SM63 LM44 C44 M130 SM63 LM44 C44 E273 M130 SM63 LM44 C44 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C42 Elizabeth LM42 C42 SM59 LM42 C42 M124 SM59 LM42 C42 E264 M124 SM59 LM42 C42 
C41 Brandon LM41 C41 SM58 LM41 C41 M120 SM58 LM41 C41 E256 M120 SM58 LM41 C41 
C41 Brandon LM41 C41 SM58 LM41 C41 M120 SM58 LM41 C41 E256 M120 SM58 LM41 C41 
C41 Brandon LM41 C41 SM58 LM41 C41 M120 SM58 LM41 C41 E256 M120 SM58 LM41 C41 
C41 Brandon LM41 C41 SM58 LM41 C41 M120 SM58 LM41 C41 E256 M120 SM58 LM41 C41 
C41 Brandon LM41 C41 SM58 LM41 C41 M120 SM58 LM41 C41 E256 M120 SM58 LM41 C41 
C41 Brandon LM41 C41 SM58 LM41 C41 M120 SM58 LM41 C41 E256 M120 SM58 LM41 C41 
C41 Brandon LM41 C41 SM58 LM41 C41 M120 SM58 LM41 C41 E256 M120 SM58 LM41 C41 
C41 Brandon LM41 C41 SM58 LM41 C41 M120 SM58 LM41 C41 E256 M120 SM58 LM41 C41 
C41 Brandon LM41 C41 SM58 LM41 C41 M120 SM58 LM41 C41 E256 M120 SM58 LM41 C41 
C41 Brandon LM41 C41 SM58 LM41 C41 M120 SM58 LM41 C41 E256 M120 SM58 LM41 C41 
C41 Brandon LM41 C41 SM58 LM41 C41 M120 SM58 LM41 C41 E256 M120 SM58 LM41 C41 
C41 Brandon LM41 C41 SM58 LM41 C41 M120 SM58 LM41 C41 E256 M120 SM58 LM41 C41 
C100 Aaron LM100 C100 SM144 LM100 C100 M284 SM144 LM100 C100 E577 M284 SM144 LM100 C100 
C100 Aaron LM100 C100 SM144 LM100 C100 M284 SM144 LM100 C100 E577 M284 SM144 LM100 C100 
C100 Aaron LM100 C100 SM144 LM100 C100 M284 SM144 LM100 C100 E577 M284 SM144 LM100 C100 
C100 Aaron LM100 C100 SM144 LM100 C100 M284 SM144 LM100 C100 E577 M284 SM144 LM100 C100 
C100 Aaron LM100 C100 SM144 LM100 C100 M284 SM144 LM100 C100 E577 M284 SM144 LM100 C100 
C100 Aaron LM100 C100 SM144 LM100 C100 M284 SM144 LM100 C100 E577 M284 SM144 LM100 C100 
C100 Aaron LM100 C100 SM144 LM100 C100 M284 SM144 LM100 C100 E577 M284 SM144 LM100 C100 
C100 Aaron LM100 C100 SM144 LM100 C100 M284 SM144 LM100 C100 E577 M284 SM144 LM100 C100 
C100 Aaron LM100 C100 SM144 LM100 C100 M284 SM144 LM100 C100 E577 M284 SM144 LM100 C100 
C100 Aaron LM100 C100 SM144 LM100 C100 M284 SM144 LM100 C100 E577 M284 SM144 LM100 C100 
C100 Aaron LM100 C100 SM144 LM100 C100 M284 SM144 LM100 C100 E577 M284 SM144 LM100 C100 
C100 Aaron LM100 C100 SM144 LM100 C100 M284 SM144 LM100 C100 E577 M284 SM144 LM100 C100 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M187 SM93 LM65 C65 E383 M187 SM93 LM65 C65 
C41 Brandon LM41 C41 SM57 LM41 C41 M119 SM57 LM41 C41 E252 M119 SM57 LM41 C41 
C41 Brandon LM41 C41 SM57 LM41 C41 M119 SM57 LM41 C41 E252 M119 SM57 LM41 C41 
C41 Brandon LM41 C41 SM57 LM41 C41 M119 SM57 LM41 C41 E252 M119 SM57 LM41 C41 
C41 Brandon LM41 C41 SM57 LM41 C41 M119 SM57 LM41 C41 E252 M119 SM57 LM41 C41 
C41 Brandon LM41 C41 SM57 LM41 C41 M119 SM57 LM41 C41 E252 M119 SM57 LM41 C41 
C41 Brandon LM41 C41 SM57 LM41 C41 M119 SM57 LM41 C41 E252 M119 SM57 LM41 C41 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C12 Amy LM12 C12 SM15 LM12 C12 M25 SM15 LM12 C12 E59 M25 SM15 LM12 C12 
C37 Stephanie LM37 C37 SM52 LM37 C37 M108 SM52 LM37 C37 E230 M108 SM52 LM37 C37 
C37 Stephanie LM37 C37 SM52 LM37 C37 M108 SM52 LM37 C37 E230 M108 SM52 LM37 C37 
C37 Stephanie LM37 C37 SM52 LM37 C37 M108 SM52 LM37 C37 E230 M108 SM52 LM37 C37 
C37 Stephanie LM37 C37 SM52 LM37 C37 M108 SM52 LM37 C37 E230 M108 SM52 LM37 C37 
C37 Stephanie LM37 C37 SM52 LM37 C37 M108 SM52 LM37 C37 E230 M108 SM52 LM37 C37 
C37 Stephanie LM37 C37 SM52 LM37 C37 M108 SM52 LM37 C37 E230 M108 SM52 LM37 C37 
C86 James LM86 C86 SM125 LM86 C86 M248 SM125 LM86 C86 E510 M248 SM125 LM86 C86 
C86 James LM86 C86 SM125 LM86 C86 M248 SM125 LM86 C86 E510 M248 SM125 LM86 C86 
C86 James LM86 C86 SM125 LM86 C86 M248 SM125 LM86 C86 E510 M248 SM125 LM86 C86 
C86 James LM86 C86 SM125 LM86 C86 M248 SM125 LM86 C86 E510 M248 SM125 LM86 C86 
C86 James LM86 C86 SM125 LM86 C86 M248 SM125 LM86 C86 E510 M248 SM125 LM86 C86 
C86 James LM86 C86 SM125 LM86 C86 M248 SM125 LM86 C86 E510 M248 SM125 LM86 C86 
C86 James LM86 C86 SM125 LM86 C86 M248 SM125 LM86 C86 E510 M248 SM125 LM86 C86 
C86 James LM86 C86 SM125 LM86 C86 M248 SM125 LM86 C86 E510 M248 SM125 LM86 C86 
C86 James LM86 C86 SM125 LM86 C86 M248 SM125 LM86 C86 E510 M248 SM125 LM86 C86 
C33 David LM33 C33 SM45 LM33 C33 M88 SM45 LM33 C33 E189 M88 SM45 LM33 C33 
C33 David LM33 C33 SM45 LM33 C33 M88 SM45 LM33 C33 E189 M88 SM45 LM33 C33 
C33 David LM33 C33 SM45 LM33 C33 M88 SM45 LM33 C33 E189 M88 SM45 LM33 C33 
C33 David LM33 C33 SM45 LM33 C33 M88 SM45 LM33 C33 E189 M88 SM45 LM33 C33 
C33 David LM33 C33 SM45 LM33 C33 M88 SM45 LM33 C33 E189 M88 SM45 LM33 C33 
C33 David LM33 C33 SM45 LM33 C33 M88 SM45 LM33 C33 E189 M88 SM45 LM33 C33 
C33 David LM33 C33 SM45 LM33 C33 M88 SM45 LM33 C33 E189 M88 SM45 LM33 C33 
C33 David LM33 C33 SM45 LM33 C33 M88 SM45 LM33 C33 E189 M88 SM45 LM33 C33 
C33 David LM33 C33 SM45 LM33 C33 M88 SM45 LM33 C33 E189 M88 SM45 LM33 C33 
C33 David LM33 C33 SM45 LM33 C33 M88 SM45 LM33 C33 E189 M88 SM45 LM33 C33 
C33 David LM33 C33 SM45 LM33 C33 M88 SM45 LM33 C33 E189 M88 SM45 LM33 C33 
C33 David LM33 C33 SM45 LM33 C33 M88 SM45 LM33 C33 E189 M88 SM45 LM33 C33 
C65 Phillip LM65 C65 SM93 LM65 C65 M186 SM93 LM65 C65 E380 M186 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M186 SM93 LM65 C65 E380 M186 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M186 SM93 LM65 C65 E380 M186 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M186 SM93 LM65 C65 E380 M186 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M186 SM93 LM65 C65 E380 M186 SM93 LM65 C65 
C65 Phillip LM65 C65 SM93 LM65 C65 M186 SM93 LM65 C65 E380 M186 SM93 LM65 C65 
C71 Ann LM71 C71 SM102 LM71 C71 M204 SM102 LM71 C71 E419 M204 SM102 LM71 C71 
C71 Ann LM71 C71 SM102 LM71 C71 M204 SM102 LM71 C71 E419 M204 SM102 LM71 C71 
C71 Ann LM71 C71 SM102 LM71 C71 M204 SM102 LM71 C71 E419 M204 SM102 LM71 C71 
C71 Ann LM71 C71 SM102 LM71 C71 M204 SM102 LM71 C71 E419 M204 SM102 LM71 C71 
C9 Joe LM9 C9 SM12 LM9 C9 M18 SM12 LM9 C9 E45 M18 SM12 LM9 C9 
C9 Joe LM9 C9 SM12 LM9 C9 M18 SM12 LM9 C9 E45 M18 SM12 LM9 C9 
C9 Joe LM9 C9 SM12 LM9 C9 M18 SM12 LM9 C9 E45 M18 SM12 LM9 C9 
C9 Joe LM9 C9 SM12 LM9 C9 M18 SM12 LM9 C9 E45 M18 SM12 LM9 C9 
C9 Joe LM9 C9 SM12 LM9 C9 M18 SM12 LM9 C9 E45 M18 SM12 LM9 C9 
C9 Joe LM9 C9 SM12 LM9 C9 M18 SM12 LM9 C9 E45 M18 SM12 LM9 C9 
C57 Martin LM57 C57 SM81 LM57 C57 M164 SM81 LM57 C57 E340 M164 SM81 LM57 C57 
C57 Martin LM57 C57 SM81 LM57 C57 M164 SM81 LM57 C57 E340 M164 SM81 LM57 C57 
C57 Martin LM57 C57 SM81 LM57 C57 M164 SM81 LM57 C57 E340 M164 SM81 LM57 C57 
C57 Martin LM57 C57 SM81 LM57 C57 M164 SM81 LM57 C57 E340 M164 SM81 LM57 C57 
C57 Martin LM57 C57 SM81 LM57 C57 M164 SM81 LM57 C57 E340 M164 SM81 LM57 C57 
C57 Martin LM57 C57 SM81 LM57 C57 M164 SM81 LM57 C57 E340 M164 SM81 LM57 C57 
C44 Lawrence LM44 C44 SM63 LM44 C44 M131 SM63 LM44 C44 E274 M131 SM63 LM44 C44 
C44 Lawrence LM44 C44 SM63 LM44 C44 M131 SM63 LM44 C44 E274 M131 SM63 LM44 C44 
C44 Lawrence LM44 C44 SM63 LM44 C44 M131 SM63 LM44 C44 E274 M131 SM63 LM44 C44 
C62 John LM62 C62 SM88 LM62 C62 M177 SM88 LM62 C62 E366 M177 SM88 LM62 C62 
C62 John LM62 C62 SM88 LM62 C62 M177 SM88 LM62 C62 E366 M177 SM88 LM62 C62 
C62 John LM62 C62 SM88 LM62 C62 M177 SM88 LM62 C62 E366 M177 SM88 LM62 C62 
C62 John LM62 C62 SM88 LM62 C62 M177 SM88 LM62 C62 E366 M177 SM88 LM62 C62 
C62 John LM62 C62 SM88 LM62 C62 M177 SM88 LM62 C62 E366 M177 SM88 LM62 C62 
C62 John LM62 C62 SM88 LM62 C62 M177 SM88 LM62 C62 E366 M177 SM88 LM62 C62 
C62 John LM62 C62 SM88 LM62 C62 M177 SM88 LM62 C62 E366 M177 SM88 LM62 C62 
C62 John LM62 C62{-truncated-}

 

 

두 번째 시도

# 2회차 풀이
SELECT  EM.company_code,
CM.founder,
COUNT(DISTINCT(LM.lead_manager_code)),
COUNT(DISTINCT(SM.senior_manager_code)),
COUNT(DISTINCT(MA.manager_code)),
COUNT(DISTINCT(EM.employee_code))


FROM EMPLOYEE EM
    LEFT JOIN MANAGER MA ON EM.manager_code = MA.manager_code
    LEFT JOIN SENIOR_MANAGER SM ON EM.senior_manager_code = SM.senior_manager_code
    LEFT JOIN LEAD_MANAGER LM ON EM.lead_manager_code = LM.lead_manager_code
    LEFT JOIN COMPANY CM ON EM.company_code = CM.company_code
    
GROUP BY EM.company_code, CM.founder
  • 그냥 employee 기준으로 다 엮어 버림

 

'HackerRank-My SQL' 카테고리의 다른 글

Prepare > SQL > Basic Select > Revising the Select Query II  (0) 2023.07.06
Prepare > SQL > Basic Select > Revising the Select Query I  (0) 2023.07.06
Prepare > SQL > Advanced Join > 15 Days of Learning SQL  (0) 2023.06.19
Prepare > SQL > Advanced Select > Occupations  (0) 2023.06.14
Prepare > SQL > Aggregation > Weather Observation Station 20  (0) 2023.06.14

관련글

티스토리툴바