Find the difference between the total number of&nbsp;<span style="border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: bolder; font-stretch: inherit; line-height: inherit; font-family: OpenSans, Arial, Helvetica, sans-serif; font-size: 14px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: var(--color-text-dark); background-color: #ffffff;">CITY&nbsp;entries in the table and the number of distinct&nbsp;<span style="border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: bolder; font-stretch: inherit; line-height: inherit; font-family: OpenSans, Arial, Helvetica, sans-serif; font-size: 14px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: var(--color-text-dark); background-color: #ffffff;">CITY&nbsp;entries in the table. The&nbsp;<span style="border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: bolder; font-stretch: inherit; line-height: inherit; font-family: OpenSans, Arial, Helvetica, sans-serif; font-size: 14px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: var(--color-text-dark); background-color: #ffffff;">STATION&nbsp;table is described as follows:
&nbsp;
이거구요&nbsp;
&nbsp;
답을
SELECT COUNT(city) - COUNT (distinct city)
FROM station&nbsp;
&nbsp;
했는데 애러만 나와요ㅠㅠ&nbsp;

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

해커랭크 마지막문제 4번 다릅니다.