<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">선생님이 짜주신 쿼리 동일하게 작성했을때 계속 오류가 노출됩니다.</div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">&nbsp;</div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;"><span style="color: #abb0b5;"><span style="font-size: 15px; letter-spacing: -0.3px; white-space: pre-wrap;">SELECT salary*months AS earnigs, COUNT(*) FROM Employee GROUP BY earnings ORDER BY earnings DESC LIMIT 1</span></span></div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">&nbsp;</div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">&nbsp;</div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;"><span style="color: #abb0b5;"><span style="font-size: 15px; letter-spacing: -0.3px; white-space: pre-wrap;">오류내용</span></span></div>
<div class="type-placeholder" style="font-size: 15px; letter-spacing: -0.3px; color: #abb0b5; white-space: pre-wrap;">
<pre class="lines-container__content" style="border: none; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: bold; font-stretch: inherit; line-height: inherit; font-family: var(--font-family-input); font-size: 14px; margin-top: 0px; margin-bottom: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: #0e141e; background-color: #f3f7f7; white-space: pre-wrap;">ERROR 1054 (42S22) at line 1: Unknown column 'earnings' in 'group statement'</pre>
</div>

<p>안녕하세요 :) SELECT 절에 오타가 있는 것 같아요. 'earnigs' 를 'earnings' 로 수정해주시면 될 것 같습니다.</p>

인프런 커뮤니티 질문&답변

TOP EARNERS 오류