select E.Name as Employee from Employee  as E inner join Employee as M on E.id = M.id where  E.salary >  M.salary ; 실행해도 values가  빈리스트로 나오더라구요. Output {"headers": ["Employee"], "values": []} Diff Expected {"headers": ["Employee"], "values": [["Joe"]]}

안녕하세요 강사님 강의 잘 보았습니다. 다름이 아니라 실무에서 분석가로 활동하기 위한 수학적 역량은 어느 정도가 필요할까요? 통계 혹은 미적분학에 대한 지식이 필요한 것 같은데, 어느 정도 깊이로 공부해야 도움이 될지 궁금합니다. 답변 미리 감사드립니다.

입력받은 문자열을 거꾸로 출력해주는 함수는 어떻게 만드는지 궁금합니다..!

dlib을 설치하는데 계속 이런 에러가 떠서 찾아보고 해봤는데 계속 안되는데 왜 그런지 알려주실 수 있을까요.. (ComputerVision) usang-in-ui-MacBook-Pro:~ usang-in$ pip3 install dlib Collecting dlib   Using cached https://files.pythonhosted.org/packages/63/92/05c3b98636661cb80d190a5a777dd94effcc14c0f6893222e5ca81e74fbc/dlib-19.19.0.tar.gz Building wheels for collected packages: dlib   Running setup.py bdist_wheel for dlib ... error   Complete output from command /Library/Frameworks/Python.framework/Versions/3.6/bin/python3.6 -u -c "import setuptools, tokenize;__file__='/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-wheel-ecxo61rx --python-tag cp36:   running bdist_wheel   running build   running build_py   package init file 'dlib/__init__.py' not found (or not a regular file)   running build_ext   Building extension for Python 3.6.7 (v3.6.7:6ec5cf24b7, Oct 20 2018, 03:02:14)   Invoking CMake setup: 'cmake /private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/tools/python -DCMAKE_LIBRARY_OUTPUT_DIRECTORY=/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/build/lib.macosx-10.9-x86_64-3.6 -DPYTHON_EXECUTABLE=/Library/Frameworks/Python.framework/Versions/3.6/bin/python3.6 -DCMAKE_BUILD_TYPE=Release'   -- The C compiler identification is unknown   -- The CXX compiler identification is unknown   -- Check for working C compiler: /usr/bin/cc   -- Check for working C compiler: /usr/bin/cc -- broken   CMake Error at /Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/cmake/data/CMake.app/Contents/share/cmake-3.16/Modules/CMakeTestCCompiler.cmake:60 (message):     The C compiler          "/usr/bin/cc"        is not able to compile a simple test program.        It fails with the following output:          Change Dir: /private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/build/temp.macosx-10.9-x86_64-3.6/CMakeFiles/CMakeTmp          Run Build Command(s):/usr/bin/make cmTC_475b6/fast && xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun                    CMake will not be able to correctly generate this project.   Call Stack (most recent call first):     CMakeLists.txt:3 (project)         -- Configuring incomplete, errors occurred!   See also "/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/build/temp.macosx-10.9-x86_64-3.6/CMakeFiles/CMakeOutput.log".   See also "/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/build/temp.macosx-10.9-x86_64-3.6/CMakeFiles/CMakeError.log".   Traceback (most recent call last):     File "<string>", line 1, in <module>     File "/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/setup.py", line 261, in <module>       'Topic :: Software Development',     File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/setuptools/__init__.py", line 129, in setup       return distutils.core.setup(**attrs)     File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/core.py", line 148, in setup       dist.run_commands()     File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/dist.py", line 955, in run_commands       self.run_command(cmd)     File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/dist.py", line 974, in run_command       cmd_obj.run()     File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/wheel/bdist_wheel.py", line 188, in run       self.run_command('build')     File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/cmd.py", line 313, in run_command       self.distribution.run_command(command)     File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/dist.py", line 974, in run_command       cmd_obj.run()     File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/command/build.py", line 135, in run       self.run_command(cmd_name)     File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/cmd.py", line 313, in run_command       self.distribution.run_command(command)     File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/dist.py", line 974, in run_command       cmd_obj.run()     File "/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/setup.py", line 135, in run       self.build_extension(ext)     File "/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/setup.py", line 172, in build_extension       subprocess.check_call(cmake_setup, cwd=build_folder)     File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/subprocess.py", line 291, in check_call       raise CalledProcessError(retcode, cmd)   subprocess.CalledProcessError: Command '['cmake', '/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/tools/python', '-DCMAKE_LIBRARY_OUTPUT_DIRECTORY=/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/build/lib.macosx-10.9-x86_64-3.6', '-DPYTHON_EXECUTABLE=/Library/Frameworks/Python.framework/Versions/3.6/bin/python3.6', '-DCMAKE_BUILD_TYPE=Release']' returned non-zero exit status 1.      ----------------------------------------   Failed building wheel for dlib   Running setup.py clean for dlib Failed to build dlib Installing collected packages: dlib   Running setup.py install for dlib ... error     Complete output from command /Library/Frameworks/Python.framework/Versions/3.6/bin/python3.6 -u -c "import setuptools, tokenize;__file__='/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-record-m5vnrry6/install-record.txt --single-version-externally-managed --compile:     running install     running build     running build_py     package init file 'dlib/__init__.py' not found (or not a regular file)     running build_ext     Building extension for Python 3.6.7 (v3.6.7:6ec5cf24b7, Oct 20 2018, 03:02:14)     Invoking CMake setup: 'cmake /private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/tools/python -DCMAKE_LIBRARY_OUTPUT_DIRECTORY=/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/build/lib.macosx-10.9-x86_64-3.6 -DPYTHON_EXECUTABLE=/Library/Frameworks/Python.framework/Versions/3.6/bin/python3.6 -DCMAKE_BUILD_TYPE=Release'     -- The C compiler identification is unknown     -- The CXX compiler identification is unknown     -- Check for working C compiler: /usr/bin/cc     -- Check for working C compiler: /usr/bin/cc -- broken     CMake Error at /Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/cmake/data/CMake.app/Contents/share/cmake-3.16/Modules/CMakeTestCCompiler.cmake:60 (message):       The C compiler              "/usr/bin/cc"            is not able to compile a simple test program.            It fails with the following output:              Change Dir: /private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/build/temp.macosx-10.9-x86_64-3.6/CMakeFiles/CMakeTmp              Run Build Command(s):/usr/bin/make cmTC_0561c/fast && xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools), missing xcrun at: /Library/Developer/CommandLineTools/usr/bin/xcrun                                CMake will not be able to correctly generate this project.     Call Stack (most recent call first):       CMakeLists.txt:3 (project)               -- Configuring incomplete, errors occurred!     See also "/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/build/temp.macosx-10.9-x86_64-3.6/CMakeFiles/CMakeOutput.log".     See also "/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/build/temp.macosx-10.9-x86_64-3.6/CMakeFiles/CMakeError.log".     Traceback (most recent call last):       File "<string>", line 1, in <module>       File "/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/setup.py", line 261, in <module>         'Topic :: Software Development',       File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/setuptools/__init__.py", line 129, in setup         return distutils.core.setup(**attrs)       File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/core.py", line 148, in setup         dist.run_commands()       File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/dist.py", line 955, in run_commands         self.run_command(cmd)       File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/dist.py", line 974, in run_command         cmd_obj.run()       File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages/setuptools/command/install.py", line 61, in run         return orig.install.run(self)       File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/command/install.py", line 545, in run         self.run_command('build')       File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/cmd.py", line 313, in run_command         self.distribution.run_command(command)       File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/dist.py", line 974, in run_command         cmd_obj.run()       File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/command/build.py", line 135, in run         self.run_command(cmd_name)       File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/cmd.py", line 313, in run_command         self.distribution.run_command(command)       File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/distutils/dist.py", line 974, in run_command         cmd_obj.run()       File "/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/setup.py", line 135, in run         self.build_extension(ext)       File "/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/setup.py", line 172, in build_extension         subprocess.check_call(cmake_setup, cwd=build_folder)       File "/Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/subprocess.py", line 291, in check_call         raise CalledProcessError(retcode, cmd)     subprocess.CalledProcessError: Command '['cmake', '/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/tools/python', '-DCMAKE_LIBRARY_OUTPUT_DIRECTORY=/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/build/lib.macosx-10.9-x86_64-3.6', '-DPYTHON_EXECUTABLE=/Library/Frameworks/Python.framework/Versions/3.6/bin/python3.6', '-DCMAKE_BUILD_TYPE=Release']' returned non-zero exit status 1.          ---------------------------------------- Command "/Library/Frameworks/Python.framework/Versions/3.6/bin/python3.6 -u -c "import setuptools, tokenize;__file__='/private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-record-m5vnrry6/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /private/var/folders/_2/f0m32tsj68sf2fx0l4nhmh7w0000gn/T/pip-install-trs12u8b/dlib/ You are using pip version 10.0.1, however version 20.0.2 is available. You should consider upgrading via the 'pip install --upgrade pip' command.

계속 영상을 만들고 계신가요? 

requests.get함수로 가져온 결과를 파싱한 결과가 제대로 나오지 않는것 같습니다.왜 그럴까요?

안녕하세요~ 주말을 맞이하여 엑셀 공부중인데 궁금한 점이 있어 문의 드립니다. 엑셀 함수 입력할때 절대 참조는 무엇을 눌러야 바로 서식이 걸리나요? 인터넷에 찾아봐도 안나오네요ㅠㅠ 좋은 수업 감사합니다.

수업자료(PPT)도 올려주셨으면 좋겠습니다.

13:48 Human h1 = st; //h1은 자식인 student를 가리키고 있다 라고하셨는데  st ->h1으로 대입 즉, student가 Human으로 아닌가 싶습니다. 업캐스팅이라고 하죠 자식이 부모클래스에 접근하는 방식이니까요.  Student st2 = h1 as Student;  // h1 -> st2 즉, Human이 stduent으로 부모클래스에서 자식 클래스로 다운캐스팅 이라고 알고있습니다. 궁금한걸 정리하자면, 부모클래스가 자식클래스로의 접근이 가능하다고 하시고 자식클래스가 부모클래스로 접근이 불가능하다고 하셨는데 반대가 아닌가 싶습니다. 제가 지식이 짧아서 이해가 부족합니다. 어떤 표현이 맞는지 알려주세요.

마지막 hackerrank 상위 문제에서 (union 문제) -- SELECT x,y From Functions WHERE x=y GROUP BY x, y HAVING COUNT(x)=2 --  이 부분의 group by를 해결하는 데에 어려움을 겪었습니다 group by에 두 개 이상의 column을 쓰는 것이 잘 이해가 되지 않아 검색하다가 해당 링크를 찾았는데요 https://dev.mysql.com/doc/refman/8.0/en/group-by-modifiers.html 제가 판단하기로는 group by에 복수 column을 쓰는 경우 곱진법(모든 경우의 수..?)에 의해 모든 가능한 수가 다 나오므로 가능한 것 같더라고요.. 해당 문제에서 ' group by x,y ' 를 쓴 이유도 마찬가지인가요..?? 모든 가능한 수를 중복되지 않게 보이기 위해..???

삭제된 글입니다

코딩 생초보인데요 캡슐화 강의 중에 나온 this의 역할과 의미가 정확히 무엇인지 알려주시면 감사하겠습니다 var value1 : int set(v1){ println("setter가 호출되었습니다") this.a1 = v1 }

제가 위 강좌를 토대로 제 개인프로젝트를 만들었는데  다른점은 백엔드를 express로 안쓴다는점입니다. spring boot를 사용했는데 궁금한점이 있습니다. _app.js에 getInitialProps에서 isServer인경우 axios.defaults.headers.Cookie = cookie; 이런식으로 저장했는데 제 크롬에서 cookie가 날리고 완전새로고침을 해서 접속해도 axios.default.headers.Cookie값에는 cookie값이 남아있고 (ctx.req.headers.cookie에는 cookie값이 undefined입니다. 오직 axios값에만 저장되어있네요) 다른 기기로 처음접속해도 위 값이 찍히는데 위 같은경우는 왜 발생하는것인가요? 어떻게 해결해야할까요?

처음 강사를 시작하면 등록이 안되더라구요. 한번이라도 학교에서 강의를 해본 분들만 등록이 되는거 같은데 제가 잘못 알고 있는건가요?ㅠㅠ 이 부분에 대한 언급도 필요할 것 같습니다.

aaa.bbb로 적으면 bbb가 붉은색 aaa.bbb()로 적으면 bbb가 파란색이 됩니다. 둘 다 메소드라 생각했는데 차이가 무엇인지 궁금하고, 붉은색/파란색 글자의 의미도 설명해주시면 감사드리겠습니다.

강의에 맞게 v ray를 설정하였는데, bump랑 displacement가 렌더링을 하면 적용이 되질 않습니다.  asset editor 에선 적용이 되어있구요... 버전은 스케치업 2019입니다.

지금 C++강의를 듣는데 C강의랑 초반에 겹치는 부분이 있어서 그런데 어떻게 수강하는게 좋을지 여쭤보고 싶습니다.

선생님 강사님 박사님.. 강의를 한번 쭉 듣고나서 컴퓨터 앞에 앉아서 따라하면서 만들어가는 중입니다. 만들어지는걸 보면서 따라하니까 너무 재밌네요. 카테고리 생성까지만 따라한 후 vultr 가상서버호스팅을 시도하는데 오류가 나요.. 일반 터미널에서는 python manage.py makemigrations/migrate/runserver가 모두 정상 작동하는데 비해 root@vultr에서는 on_delete must be callable. 에러가 나서 넘어가질 않아요. models.py에서 수정을 하고 다시 해보아도 수정 사항이 반영되지 않은 상태로 같은 오류 메세지가 나오는데 어떻게 수정해야 할까요? django는 2.2 버전을 설치했어요. (강의 중에는 vultr에서 elvis_admin으로 로그인 하시던데 elvis_admin을 어느 항목에서 가져온지 몰라서 Root의 가상 환경에서 하고 있어요.) 아래는 터미널 창 오류 메세지 인데요, 어떻게 수정을 해야 넘어갈 수 있을지 조언 부탁 드립니다. 감사합니다. ^C(venv) root@vultr:~/github/djangoyuri2.2# python manage.py makemigrations Traceback (most recent call last): File "manage.py", line 21, in <module> main() File "manage.py", line 17, in main execute_from_command_line(sys.argv) File "/root/github/djangoyuri2.2/venv/lib/python3.6/site-packages/django/core/management/__init__.py", line 401, in execute_from_command_line utility.execute() File "/root/github/djangoyuri2.2/venv/lib/python3.6/site-packages/django/core/management/__init__.py", line 377, in execute django.setup() File "/root/github/djangoyuri2.2/venv/lib/python3.6/site-packages/django/__init__.py", line 24, in setup apps.populate(settings.INSTALLED_APPS) File "/root/github/djangoyuri2.2/venv/lib/python3.6/site-packages/django/apps/registry.py", line 114, in populate app_config.import_models() File "/root/github/djangoyuri2.2/venv/lib/python3.6/site-packages/django/apps/config.py", line 211, in import_models self.models_module = import_module(models_module_name) File "/usr/lib/python3.6/importlib/__init__.py", line 126, in import_module return _bootstrap._gcd_import(name[level:], package, level) File "<frozen importlib._bootstrap>", line 994, in _gcd_import File "<frozen importlib._bootstrap>", line 971, in _find_and_load File "<frozen importlib._bootstrap>", line 955, in _find_and_load_unlocked File "<frozen importlib._bootstrap>", line 665, in _load_unlocked File "<frozen importlib._bootstrap_external>", line 678, in exec_module File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed File "/root/github/djangoyuri2.2/blog/models.py", line 34, in <module> class Post(models.Model): File "/root/github/djangoyuri2.2/blog/models.py", line 41, in Post author = models.ForeignKey(User, on_delete=True) File "/root/github/djangoyuri2.2/venv/lib/python3.6/site-packages/django/db/models/fields/related.py", line 801, in __init__ raise TypeError('on_delete must be callable.') TypeError: on_delete must be callable.

\왜이러는지 모르겠는데,, 중국어가 뜨네요

클래스파트 연산자 오버로딩 강의를 보면 부모 클래스의 메서드를 자식클래스에서 재정의하는건데 연산자 오버로딩이 아니고 메서드 오버라이딩 아닌가요?