SMASMC SMASMC

SQL

• 조건에 맞는 도서 리스트 출력하기

  SQL 2024. 2. 6. 02:19

  SELECT BOOK_ID, DATE_FORMAT(PUBLISHED_DATE,'%Y-%m-%d') as PUBLISHED_DATE FROM BOOK WHERE CATEGORY = '인문' AND YEAR(PUBLISHED_DATE) = '2021' ORDER BY PUBLISHED_DATE DESC

  Read More
• 평균 일일 대여 요금 구하기

  SQL 2024. 2. 6. 00:45

  SELECT ROUND(SUM(DAILY_FEE)/COUNT(CAR_ID)) as AVERAGE_FEE FROM CAR_RENTAL_COMPANY_CAR WHERE CAR_TYPE ="SUV"

  Read More