문제Write a solution to find the second highest distinct salary from the Employee table. If there is no second highest salary, return null (return None in Pandas). Employee 테이블에서 두번째로 높은 연봉을 출력한다. 만약 없다면 null을 출력한다. 쿼리SELECT MAX(a.salary) AS SecondHighestSalaryFROM ( SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS r FROM Employee..

3월에 태어난 여성 회원 목록 출력하기SELECT MEMBER_ID, MEMBER_NAME, GENDER, date_format(DATE_OF_BIRTH, '%Y-%m-%d') as DATE_OF_BIRTH from member_profile where month(date_of_birth) = 3 and TLNO is not nulland Gender ='W'order by member_id asc; 재구매가 일어난 상품과 회원 리스트 구하기SELECT USER_ID, PRODUCT_ID FROM(SELECT USER_ID, PRODUCT_ID, COUNT(SALES_AMOUNT) AS CNT FROM ONLINE_SALEGROUP BY USER_ID, PRODUCT_ID) SUBWHERE CNT>1OR..