Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
2- From the following tables write a SQL query to find the departments with budgets more than Rs. 50000 and display the first name and las name of employees ?

2- From the following tables write a SQL query to find the departments with budgets more than Rs. 50000 and display the first name and las name of employees ?

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

using oracle

Using oracle 2- From the following tables write a SQL query to find the departments with budgets more than Rs. 50000 and display the first name and las name of employees ? company_mast COM ID COM NAME 11 Samsung 12 iBall 13 Epsion 14 Zebronics 15 Asus 16 Frontech item_mast PRO ID PRO_NAME 101 Mother Board. 102 Key Board 103 ZIP drive 104 Speaker 105 105 Monitor 106 DVD drive 107 CD drive 108 Printer 109 Refill cartridge 110 Mouse emp_department DPT CODE DPT_NAME 57 IT 63 Finance. 47 HR 27 RD 89 QC 127323 Michale 526689 Carlos. 843795 Enric 328717 Jhon 444527 Joseph 659831 Zanifer 847674 Kuleswar 748681 Henrey 555935 Alex 539569 George 733843 Mario 631548 Alan 839139 Maria aid PRO_PRICE 15000 240000 55000 75000 EMP LNAME Robbin Snares Dosio Snares Dosni Emily Sitaraman Gabriel Manuel Mardy Saule Snappy Foster ques abah EMP DEPT 57 63 57 63 47 47 57 47 57 27 63 27 57
Transcribed Image Text:Using oracle 2- From the following tables write a SQL query to find the departments with budgets more than Rs. 50000 and display the first name and las name of employees ? company_mast COM ID COM NAME 11 Samsung 12 iBall 13 Epsion 14 Zebronics 15 Asus 16 Frontech item_mast PRO ID PRO_NAME 101 Mother Board. 102 Key Board 103 ZIP drive 104 Speaker 105 105 Monitor 106 DVD drive 107 CD drive 108 Printer 109 Refill cartridge 110 Mouse emp_department DPT CODE DPT_NAME 57 IT 63 Finance. 47 HR 27 RD 89 QC 127323 Michale 526689 Carlos. 843795 Enric 328717 Jhon 444527 Joseph 659831 Zanifer 847674 Kuleswar 748681 Henrey 555935 Alex 539569 George 733843 Mario 631548 Alan 839139 Maria aid PRO_PRICE 15000 240000 55000 75000 EMP LNAME Robbin Snares Dosio Snares Dosni Emily Sitaraman Gabriel Manuel Mardy Saule Snappy Foster ques abah EMP DEPT 57 63 57 63 47 47 57 47 57 27 63 27 57
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS