Page 1 of 1

وار Open Oracle Live SQL and try all the following queries. Given Three Tables (hr.Employees, hr.Departments, and hr.job

Posted: Fri May 20, 2022 10:50 am
by answerhappygod
 1
1 (23.87 KiB) Viewed 32 times
 2
2 (19.93 KiB) Viewed 32 times
 3
3 (21.81 KiB) Viewed 32 times
 4
4 (20.47 KiB) Viewed 32 times
 5
5 (17.86 KiB) Viewed 32 times
وار Open Oracle Live SQL and try all the following queries. Given Three Tables (hr.Employees, hr.Departments, and hr.jobs). Note: You can know about the structure of these tables using Describe Command. الأدوات، اغلى MT+F10 الكسندوي شمسي او 1FN4481م ونعلم ما Mac) B با 4 A = ه 10pt ant sans-serif Paragraph الريدز "النار والارسال والمراة الحار بارک اور امان

For employees are worlding in department no 90 or department 80, Retrieve a list of Employee id, fast Name, email and Salary: (1 mark) MALT10) ALTO 2 A 1 10pt Paragraphs UIB

الرجات .retrieve list of employees First names, salaries and their job titles نامه ای ALT+F10 الكايد در دریا از ALT+FN4F10 ونظام العمل Mac) . T2A !!! 10pt ans sans-serif Paragraph S

الا الزرا For Employees who get salary between 6000 and 17000, Retrieve a list of their first name and Department names شراره له من Artin المدام در سال F40+1257 مل مل Mi قلا Tre asante Pago

راه ار For each job that has more than 2 employees, retrieve its job_id and how many employees dedicated to it (Mac) ALTEN.FO LT-10 T: 2 E! 10pt van ser Paragraph Sy TB