Day_3 (Query on Where Clause) #sq #sql2025

Description:
create table dept(
deptno decimal(2,0) not null,
dname varchar(14),
loc varchar(13));


create table emp(
empno decimal(4,0) not null,
ename varchar(10),
job varchar(9),
mgr decimal(4,0),
hiredate date,
sal decimal(7,2),
comm decimal(7,2),
deptno decimal(2,0) not null);


create table dummy (
dummy decimal);

insert into dummy values (0);


insert into DEPT (DEPTNO, DNAME, LOC)
select 10, 'ACCOUNTING', 'NEW YORK' from dummy union all
select 20, 'RESEARCH', 'DALLAS' from dummy union all
select 30, 'SALES', 'CHICAGO' from dummy union all
select 40, 'OPERATIONS', 'BOSTON' from dummy;


insert into emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
select 7839, 'KING', 'PRESIDENT', null, '1981-11-17', 5000, null, 10 union all
select 7698, 'BLAKE', 'MANAGER', 7839, '1981-05-01', 2850, null, 30 union all
select 7782, 'CLARK', 'MANAGER', 7839, '1981-06-09', 2450, null, 10 union all
select 7566, 'JONES', 'MANAGER', 7839, '1981-04-02', 2975, null, 20 union all
select 7902, 'FORD', 'ANALYST', 7566, '1981-12-03', 3000, null, 20 union all
select 7369, 'SMITH', 'CLERK', 7902, '1980-12-17', 800, null, 20 union all
select 7499, 'ALLEN', 'SALESMAN', 7698, '1981-02-20', 1600, 300, 30 union all
select 7521, 'WARD', 'SALESMAN', 7698, '1981-02-22', 1250, 500, 30 union all
select 7654, 'MARTIN', 'SALESMAN', 7698, '1981-09-28', 1250, 1400, 30 union all
select 7844, 'TURNER', 'SALESMAN', 7698, '1981-09-08', 1500, 0, 30 union all
select 7900, 'JAMES', 'CLERK', 7698, '1981-12-03', 950, null, 30 union all
select 7934, 'MILLER', 'CLERK', 7782, '1982-01-23', 1300, null, 10 union all
select 7788, 'SCOTT', 'ANALYST', 7566, '1987-07-13', 3000, null, 20 union all
select 7876, 'ADAMS', 'CLERK', 7788, '1987-07-13', 1100, null, 20 ;