SQL 20241003

20241003===========================================

# Lv 3. 대여기록이 존재하는 자동차 리스트 구하기

SELECT DISTINCT A.CAR_ID 
FROM CAR_RENTAL_COMPANY_CAR A
LEFT JOIN CAR_RENTAL_COMPANY_RENTAL_HISTORY B
ON A.CAR_ID = B.CAR_ID
WHERE A.CAR_TYPE = '세단'
AND B.START_DATE BETWEEN '2022-10-01' AND '2022-10-31' 
ORDER BY CAR_ID DESC;

# Lv. 3 조건에 맞는 사용자와 총 거래금액 조회하기

SELECT B.USER_ID,B.NICKNAME,SUM(PRICE) AS TOTAL_SALES
FROM USED_GOODS_BOARD A
LEFT JOIN USED_GOODS_USER B
ON A.WRITER_ID = B.USER_ID 
WHERE A.STATUS = 'DONE' 
GROUP BY B.USER_ID
HAVING TOTAL_SALES >= 700000
ORDER BY TOTAL_SALES;

# Lv 2. 루시와 엘라 찾기

SELECT ANIMAL_ID,NAME,SEX_UPON_INTAKE
FROM ANIMAL_INS
WHERE NAME IN ('Lucy','Ella','Pickle','Rogan','Sabrina','Mitty')
ORDER BY ANIMAL_ID;