1. Do a query that tests for condition A and condition B and show me the results. 

2. Do a query that tests for condition A or condition B or condition C and show me the results. 

3. Do a query that tests for condition A and condition B are both true or condition C and condition D EMENO ENAME JOB MGR HIREDATE SAL COMM ---------- ---------- ---- ----- --------- DEPTNO are both true. -------- 

4. Do a query that tests for condition A and condition B being true or condition C is true. 

5.Do a query that tests for condition A being true or condition B and condition C both being true. 

6. Do a query that tests for condition A being true and either condition B or condition C being true. 

  

Transcribed Image Text:

SQL> des GARL Name EMPNO ENAME JOB MGR HIREDATE SAL COMM DEFTNO SQL> select from SSSRZE JOB EMPNO ENAME DEPTNO 7369 SMITH 20 7499 ALLEN 30 7521 HARD 30 EMENO ENAME DEPTNO 7566 JONES 20 7654 MARTIN 30 7369 SMITH 20 EMPNO ENAME DEPTNO 7499 ALLEN 30 7521 WARD 30 7566 JONES 20 EMPNO ENAME DEPTNO 7654 MARTIN 30 7782 CLARK 10 7839 KING 10 EMPNO ENAME DEPTNO 7844 TURNER 30 7876 ADAMS 20 7900 JAMES 30 CLERK SALESMAN SALESMAN JOB MANAGER SALESMAN CLERK JOB SALESMAN SALESMAN MANAGER JOB SALESMAN MANAGER FRESIDENT ЈОБ SALESMAN CLERK CLERK Null? MGR HIREDATE 7902 17-DEC-80 MGR HIREDATE 7698 20-FEB-81 7698 22-FEB-81 Туре NUMBER (4) VARCHAR2 (10) VARCHAR2 (9) 7902 17-DEC-80 7839 02-APR-81 MGR HIREDATE 7698 28-SEP-81 NUMBER (4) DATE NUMBER (7,2) NUMBER (7,2) NUMBER 7698 20-FEB-81 7839 02-APR-81 MGR HIREDATE 7698 22-FEB-81 7698 28-SEP-81 7839 09-JUN-81 MGR HIREDATE 17-NOV-81 7698 08-SEP-81 7788 23-MAY-87 7698 03-DEC-81 SAL 800 1600 1250 SAL 2975 1250 800 SAL 1600 1250 2975 SAL 1250 2450 5000 SAL 1500 1100 950 COMM 300 500 COMM 1400 COMM 300 500 COMM 1400 COMM 0 SQL> des GARL Name EMPNO ENAME JOB MGR HIREDATE SAL COMM DEFTNO SQL> select from SSSRZE JOB EMPNO ENAME DEPTNO 7369 SMITH 20 7499 ALLEN 30 7521 HARD 30 EMENO ENAME DEPTNO 7566 JONES 20 7654 MARTIN 30 7369 SMITH 20 EMPNO ENAME DEPTNO 7499 ALLEN 30 7521 WARD 30 7566 JONES 20 EMPNO ENAME DEPTNO 7654 MARTIN 30 7782 CLARK 10 7839 KING 10 EMPNO ENAME DEPTNO 7844 TURNER 30 7876 ADAMS 20 7900 JAMES 30 CLERK SALESMAN SALESMAN JOB MANAGER SALESMAN CLERK JOB SALESMAN SALESMAN MANAGER JOB SALESMAN MANAGER FRESIDENT ЈОБ SALESMAN CLERK CLERK Null? MGR HIREDATE 7902 17-DEC-80 MGR HIREDATE 7698 20-FEB-81 7698 22-FEB-81 Туре NUMBER (4) VARCHAR2 (10) VARCHAR2 (9) 7902 17-DEC-80 7839 02-APR-81 MGR HIREDATE 7698 28-SEP-81 NUMBER (4) DATE NUMBER (7,2) NUMBER (7,2) NUMBER 7698 20-FEB-81 7839 02-APR-81 MGR HIREDATE 7698 22-FEB-81 7698 28-SEP-81 7839 09-JUN-81 MGR HIREDATE 17-NOV-81 7698 08-SEP-81 7788 23-MAY-87 7698 03-DEC-81 SAL 800 1600 1250 SAL 2975 1250 800 SAL 1600 1250 2975 SAL 1250 2450 5000 SAL 1500 1100 950 COMM 300 500 COMM 1400 COMM 300 500 COMM 1400 COMM 0

Answer rating: 100% (QA)

It looks like your question is about constructing SQL queries with various conditions Lets assume yo... View the full answer