[SQL문제풀기] April Admin Employees

문제

StrataScratch - April Admin Employees

StrataScratch

https://platform.stratascratch.com/coding/9845-find-the-number-of-employees-working-in-the-admin-department?code_type=3

내가 작성한 정답

Oracle, PostgreSQL, MySQL

select count(worker_id) "the number of employees"
from worker
where extract(month from joining_date) >= 4
    and department = 'Admin';

MySQL

select count(worker_id) "the number of employees"
from worker
where month(joining_date) >= 4
    and department = 'Admin';

PostgreSQL

select count(worker_id) "the number of employees"
from worker
where extract(month from joining_date) >= 4
    and department = 'Admin';

Oracle

select count(worker_id) "the number of employees"
from worker
where to_char(joining_date,'mm') >= 4
    and department = 'Admin';