AI Programming
———————————————— | Database Exercise Questions | ———————————————— N.B. Consider the database shown above in Figure DB 1.1, whose schema is shown and do the practical exercises below. (We assume you have installed Oracle’s default HR(Human Resource)…
DB - Oracle Exercise 1 :Answers
————————————————
•Ans Ex 1
SELECT * FROM JOBS WHERE JOB_TITLE LIKE ‘%A_%’;
•Ans Ex 2
SELECT DISTINCT MIN_SALARY, MAX_SALARY FROM JOBS;
•Ans Ex 3
SELECT DEPARTMENT_NAME FROM DEPARTMENTS WHERE LOCATION_ID = 1700;
•Ans Ex 4
SELECT * FROM JOBS WHERE JOB_TITLE LIKE ‘%P%’ ORDER BY MIN_SALARY;
(SELECT * FROM JOBS WHERE JOB_TITLE LIKE ‘%P%’ ORDER BY ASC MIN_SALARY;)
•Ans Ex 5
SELECT FIRST_NAME, LAST_NAME, EMAIL, SALARY FROM EMPLOYEES WHERE FIRST_NAME LIKE ‘%y’ ORDER BY EMAIL DESC;
•Ans Ex 6
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE SALARY = 12008 OR SALARY = 3000;
•Ans Ex 7
SELECT CITY, POSTAL_CODE FROM LOCATIONS WHERE CITY NOT LIKE ‘%e’ AND CITY NOT LIKE ‘%y’ AND CITY NOT LIKE ‘%a’;
•Ans Ex 8
SELECT EMPLOYEE_ID, FIRST_NAME, PHONE_NUMBER, EMAIL FROM EMPLOYEES WHERE HIRE_DATE > SYSDATE - 4000;
•Ans Ex 9
SELECT MAX(SALARY) as “Max Salary”, MIN(SALARY) as “Min Salary”, AVG(SALARY) as “Average Salary” FROM EMPLOYEES;
•Ans Ex 10
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE HIRE_DATE = ‘07-JUN-02’ AND (SALARY = 6500 OR SALARY = 8300);
AI Programming @freecodecs
————————————————
•Ans Ex 1
SELECT * FROM JOBS WHERE JOB_TITLE LIKE ‘%A_%’;
•Ans Ex 2
SELECT DISTINCT MIN_SALARY, MAX_SALARY FROM JOBS;
•Ans Ex 3
SELECT DEPARTMENT_NAME FROM DEPARTMENTS WHERE LOCATION_ID = 1700;
•Ans Ex 4
SELECT * FROM JOBS WHERE JOB_TITLE LIKE ‘%P%’ ORDER BY MIN_SALARY;
(SELECT * FROM JOBS WHERE JOB_TITLE LIKE ‘%P%’ ORDER BY ASC MIN_SALARY;)
•Ans Ex 5
SELECT FIRST_NAME, LAST_NAME, EMAIL, SALARY FROM EMPLOYEES WHERE FIRST_NAME LIKE ‘%y’ ORDER BY EMAIL DESC;
•Ans Ex 6
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE SALARY = 12008 OR SALARY = 3000;
•Ans Ex 7
SELECT CITY, POSTAL_CODE FROM LOCATIONS WHERE CITY NOT LIKE ‘%e’ AND CITY NOT LIKE ‘%y’ AND CITY NOT LIKE ‘%a’;
•Ans Ex 8
SELECT EMPLOYEE_ID, FIRST_NAME, PHONE_NUMBER, EMAIL FROM EMPLOYEES WHERE HIRE_DATE > SYSDATE - 4000;
•Ans Ex 9
SELECT MAX(SALARY) as “Max Salary”, MIN(SALARY) as “Min Salary”, AVG(SALARY) as “Average Salary” FROM EMPLOYEES;
•Ans Ex 10
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE HIRE_DATE = ‘07-JUN-02’ AND (SALARY = 6500 OR SALARY = 8300);
AI Programming @freecodecs
Today we will discuss an amazing app called ❇️source code❇️
👉over 1222 programs source code of different programming language like c,c#,c++,java,css,html,JavaScript ,php,python,xml,sql and many more programming language
💠if u want to learn about programming this app will help u 100%
✳️we uploaded the applications on our channel
┈┈┈┈••●◉❖◉●••┈┈┈
🗣➹share &Join Us
👇🏾👇🏾👇🏾 @freecodecs @freecodecs @freecodecs
┗━ ••• ━ ••━━•••━━━┛
👉over 1222 programs source code of different programming language like c,c#,c++,java,css,html,JavaScript ,php,python,xml,sql and many more programming language
💠if u want to learn about programming this app will help u 100%
✳️we uploaded the applications on our channel
┈┈┈┈••●◉❖◉●••┈┈┈
🗣➹share &Join Us
👇🏾👇🏾👇🏾 @freecodecs @freecodecs @freecodecs
┗━ ••• ━ ••━━•••━━━┛
AI Programming via @like
👻Who wants full w3school offline version?👻
Offline version is a Web pages you can view without being connected to the Internet. W3school is the best website to learn programming like SQL html/css PHP Python ...... with Exercises👍👍👍👍
😊@freecodecs
Offline version is a Web pages you can view without being connected to the Internet. W3school is the best website to learn programming like SQL html/css PHP Python ...... with Exercises👍👍👍👍
😊@freecodecs
❤2
W3Schools Offline FullTutorial.apk
12.1 MB
W3school offline apk for Android phone
@Freecodecs
@Freecodecs
Quick Sorting Character in Alphabetical Order
AI Programming @freecodecs
As always:
Have a Lit 🔥 Practice Folks 🙌🏽
AI Programming @freecodecs
As always:
Have a Lit 🔥 Practice Folks 🙌🏽