hue
username - cloudera
password - cloudera

CREATE DATABASE company_db;
USE company_db;

CREATE TABLE employees(id INT, name STRING, department STRING, salary FLOAT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE;

INSERT INTO TABLE employees VALUES (1, "Alice", "Finance", 30000);
INSERT INTO TABLE employees VALUES (2, "Bob", "Finance", 32000);
INSERT INTO TABLE employees VALUES (3, "Carl", "Finance", 34000);
INSERT INTO TABLE employees VALUES (4, "David", "Marketing", 40000);
INSERT INTO TABLE employees VALUES (5, "Elijah", "Marketing", 35000);
INSERT INTO TABLE employees VALUES (6, "Daisy", "Marketing", 45000);
INSERT INTO TABLE employees VALUES (7, "Mary", "IT", 50000);
INSERT INTO TABLE employees VALUES (8, "Tom", "IT", 55000);
INSERT INTO TABLE employees VALUES (9, "Jim", "IT", 60000);
INSERT INTO TABLE employees VALUES (10, "Freya", "IT", 57000);

SELECT * FROM employees;

SELECT department, avg(salary) AS avg_salary FROM employees GROUP BY department;

SELECT * FROM imported;

SELECT department, MIN(salary) AS min_salary FROM employees GROUP BY department;
SELECT department, MAX(salary) AS max_salary FROM employees GROUP BY department;
