Here is an example: SELECT COUNT(*), MIN(e.Wage), MAX(e.Wage) FROM Employee e WHERE e.LastName LIKE '%Jones%'; This query will always output exactly one row, counting of the number of employees whose last name contains "Jones", and giving the minimum and maximum wage found for those employees.
這裡是一個例子： SELECT COUNT(*), MIN(e.Wage), MAX(e.Wage) FROM Employee e WHERE e.LastName LIKE '%Jones%'; 此查詢將始終輸出一行，計算姓氏中包含“Jones”的員工人數，並給出這些員工的最低和最高工資。