Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Considering the table Employee (id, designation, salary, location, email, phone) Construct down queries for the following 1) Find those employees whose id b/w 1001 - 1010 and their designation = "Manager"; 2) Select designation of those in which is their gross sal > = 50000 3) Find basic salary of those whose annual salary is b/w 100000 to 500000 4) Find location, email, ph# of those whose medical allowance > 40000 5) Give increment of 10000 of those employees whose b.salary < = 15000 and annual sal < = 80000 6) Calculate 15% tax on those employees whose gross salary > = 100000 7) Find designation of those employees whose medical allowance is b/w 50000 and 70000 8) Calculate net sal (which is gross sal - tax) of all employees 9) Find dept.id of those employees whose deg = GM and their gross sal > = 10pes whose b.sal / 5 = 20000; 10) Average salary of all employees

Considering the table Employee (id, designation, salary, location, email, phone) Construct down queries for the following 1) Find those employees whose id b/w 1001 - 1010 and their designation = "Manager"; 2) Select designation of those in which is their gross sal > = 50000 3) Find basic salary of those whose annual salary is b/w 100000 to 500000 4) Find location, email, ph# of those whose medical allowance > 40000 5) Give increment of 10000 of those employees whose b.salary < = 15000 and annual sal < = 80000 6) Calculate 15% tax on those employees whose gross salary > = 100000 7) Find designation of those employees whose medical allowance is b/w 50000 and 70000 8) Calculate net sal (which is gross sal - tax) of all employees 9) Find dept.id of those employees whose deg = GM and their gross sal > = 10pes whose b.sal / 5 = 20000; 10) Average salary of all employees

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 65C: Write the SQL code to create the table structures for the entities shown in Figure P7.65. The...
See similar textbooks
icon
Related questions
Question
Considering the table Employee (id, designation, salary, location, email, phone) Construct down queries for the following 1) Find those employees whose id b/w 1001 - 1010 and their designation = "Manager"; 2) Select designation of those in which is their gross sal > = 50000 3) Find basic salary of those whose annual salary is b/w 100000 to 500000 4) Find location, email, ph# of those whose medical allowance > 40000 5) Give increment of 10000 of those employees whose b.salary < = 15000 and annual sal < = 80000 6) Calculate 15% tax on those employees whose gross salary > = 100000 7) Find designation of those employees whose medical allowance is b/w 50000 and 70000 8) Calculate net sal (which is gross sal - tax) of all employees 9) Find dept.id of those employees whose deg = GM and their gross sal > = 10pes whose b.sal / 5 = 20000; 10) Average salary of all employees
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Complex Datatypes
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS