mysql in functions

While your question is missing sample data, but this is an essay :

CREATE TABLE employees
( employee_id NUMBER
, hire_date DATE
, department_id NUMBER
) ;
INSERT INTO employees (employee_id,hire_date,department_id) VALUES (1,TO_DATE('20210101','YYYYMMDD'),5);
INSERT INTO employees (employee_id,hire_date,department_id) VALUES (5,TO_DATE('20210101','YYYYMMDD'),5);
INSERT INTO employees (employee_id,hire_date,department_id) VALUES (10,TO_DATE('20210101','YYYYMMDD'),5);
INSERT INTO employees (employee_id,hire_date,department_id) VALUES (2,TO_DATE('20210102','YYYYMMDD'),5);
INSERT INTO employees (employee_id,hire_date,department_id) VALUES (3,TO_DATE('20210102','YYYYMMDD'),1);
INSERT INTO employees (employee_id,hire_date,department_id) VALUES (23,TO_DATE('20210102','YYYYMMDD'),5);
INSERT INTO employees (employee_id,hire_date,department_id) VALUES (55,TO_DATE('20210102','YYYYMMDD'),6);
SELECT department_id, hire_date, COUNT(employee_id) AS CountOfEmployees FROM employees
GROUP BY department_id, hire_date
ORDER BY department_id, hire_date

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amira Bedhiafi5y ago
While your question is missing sample data, but this is an essay :
CREATE TABLE employees
   ( employee_id NUMBER
   , hire_date DATE
   , department_id NUMBER
   ) ;

INSERT   INTO employees (employee_id,hire_date,department_id) VALUES (1,TO_DATE('20210101','YYYYMMDD'),5);
INSERT   INTO employees (employee_id,hire_date,department_id) VALUES (5,TO_DATE('20210101','YYYYMMDD'),5);
INSERT   INTO employees (employee_id,hire_date,department_id) VALUES (10,TO_DATE('20210101','YYYYMMDD'),5);
INSERT   INTO employees (employee_id,hire_date,department_id) VALUES (2,TO_DATE('20210102','YYYYMMDD'),5);
INSERT   INTO employees (employee_id,hire_date,department_id) VALUES (3,TO_DATE('20210102','YYYYMMDD'),1);
INSERT   INTO employees (employee_id,hire_date,department_id) VALUES (23,TO_DATE('20210102','YYYYMMDD'),5);
INSERT   INTO employees (employee_id,hire_date,department_id) VALUES (55,TO_DATE('20210102','YYYYMMDD'),6);


SELECT department_id, hire_date, COUNT(employee_id) AS CountOfEmployees FROM employees
GROUP BY department_id, hire_date
ORDER BY department_id, hire_date
+1
Amira Bedhiafi5y ago
Can you please share a sample of your data and the related tables?
0
Rajanikant Hawaldar5y ago
select count(emp) as num_emp where date=.... you can order by date btn may be a group by + order by clause
0