????????????????????????

Examples

-- avg ???????????????????????????????????????
-- ?????????????????????????????????????????????????????????
SELECT NAME, COMM
  FROM STAFF
  WHERE EXISTS
    (SELECT AVG(BONUS + 800)
       FROM EMPLOYEE
       WHERE COMM < 5000
       AND EMPLOYEE.LASTNAME = UPPER(STAFF.NAME)
)
-- VALUES?????????????????????????????????????????????
-- ???????????????"??????"??????????????????
-- ??????????????????"R1"???"R2"?????????????????????????????????
-- "X"??????????????????????????????????????????????????????????????????????????????
SELECT R1,R2 
	FROM (VALUES('GROUP 1','GROUP 2')) AS X(R1,R2)