SQL Queries

select count(gender) as count_gender

from employees

where gender='F';

select * from employees

order by emp_no desc;

select dept_no,count(emp_no) as count_emp_no

from dept_emp

group by dept_no;

SELECT * FROM employees.employees;

select count(gender) as count_gender

from employees

where gender='F';

select avg(gender) as avg_gender

from employees

where gender='F';

select * from employees;

select * from dept_manager;

select * from salaries;

select * from employees

order by emp_no desc;

insert into employees(emp_no,birth_date,first_name,last_name,gender,hire_date) values(500000,'2000-03-03','Pulakunta','Janani','F','2023-11-26');

select * from dept_emp;

select dept_no,count(emp_no) as count_emp_no

from dept_emp

group by dept_no;

select * from salaries;

select d.dept_no as dept_no,sum(salary) as total_salary

from salaries as s

join dept_emp as d

using(emp_no)

group by dept_no;

select * from departments;

select avg(salary) avg_salry_per_emp,d.dept_no

from salaries as s

join dept_emp as d

using(emp_no)

group by dept_no;

select * from titles;

select title,count(emp_no) as count_emp_no

from titles

group by title

order by count_emp_no desc;

select * from dept_manager;

select emp_no,count(*) as occurence_count

from dept_manager

group by emp_no

having count(*)>1;