SQL문 복습DML (데이터 조작어) - SELECT, INSERT, UPDATE, DELETEDDL (데이터 정의어) - CREATE, ALTER, DROP, RENAMEDCL (데이터 제어어) - GRANT, REVOKE, DENYSELECT문 예시SELECT EmployedId, YEAR(OrderDate) AS OrderYearFROM Sales.OrdersWHERE CustomerId = 71GROUP BY EmployeeId, YEAR(OrderDate)HAVING COUNT(*) >1ORDER BY EMployeddId, OrderYear; CREATE문 예시CREATE TABLE Mytable(Mycolumn1 int NOT NULL PRIMARY KEY, Mycolumn2 VARCHAR(..