Big Data, Max Compute, Apache, Apache Hive, Alibabacloud.
from the employee table “emp”, define a variable B to filter the list of departments created after January 1, 2018 from the department table “dept”, and then define a variable C to count the average age of employees over 30 years old in these departments. The obtained results can be easily