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

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

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

Post by answerhappygod »

 1
1 (23.87 KiB) Viewed 31 times
 2
2 (19.93 KiB) Viewed 31 times
 3
3 (21.81 KiB) Viewed 31 times
 4
4 (20.47 KiB) Viewed 31 times
 5
5 (17.86 KiB) Viewed 31 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply