My Tech Blog (group)

1. What's Security Groups▶ Security Groups are the fundamental of network security.▶ They control how traffic is allowed into or out of our EC2 Instances.⭐ Security groups only contain allow rules - 허용규칙만 포함되므로 무엇이 들어가고 나가는 지 알 수 있다. ⭐ Security groups rules can reference by IP or by security group or other security groups - 보안 그룹은 IP주소를 기준으로 규칙을 생성한다. - 또는 다른 보안 그룹을 참조하여 설정할 수 있다. (보안그룹은 서로 참조..

쿼리1SELECT A.REST_ID, A.REST_NAME, A.FOOD_TYPE, A.FAVORITES, A.ADDRESS, ROUND(AVG(B.REVIEW_SCORE),2) AS SCOREFROM REST_INFO A INNER JOIN REST_REVIEW B ON A.REST_ID = B.REST_IDGROUP BY B.REST_IDHAVING A.ADDRESS LIKE '서울%'ORDER BY SCORE DESC, A.FAVORITES DESC 쿼리 2SELECT A.REST_ID, B.REST_NAME, B.FOOD_TYPE, B.FAVORITES, B.ADDRESS, ROUND(AVG(A.REVIEW_SCORE),2) AS SCOREFROM REST_REVIEW AJOIN REST_INFO..