Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Problem1. Express the following queries in SQL:

a) List the First Name, Last Name and telephone number of all employees who were appointed in the year 1995.

b) List all details of employee who is not managed by any employee.

c) List all details of all employees who draw a salary between 10,000 and 18,000 and whose manager_id is either 100 or 101.

d) List all the Last Name and First Name of all employees who is a president (job_id is SA_PRES) OR a sales representative (job_id is SA_REP) AND who earns more than 15000.

e) List the Last Name, First Name, salary and Annual Salary of all employees who do not get any commission. Display your result in descending order of the annual salary.

f) List the First Name, Last Name, Salary, commission_pct and a column called special which will display the special features for those employee with following condition:

• If the commission_pct value is not null, it is shown.

• If the commission_pct value is null, then the salary is shown

• If the commission_pct and salary is null, then the value 10 is shown.

g) List all the Last Name, job_id, department_id, department name for all employees who work in Toronto.

h) List all the employee last name, and employee number along with their manager’s last name and manager number. Label the column Employee, Emp#, manager Mgr#, correspondingly.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M95831

Have any Question? 


Related Questions in DBMS

Suppose that you are the database developer for a local

Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcoming training s ...

Use sql management studio to create a database called

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the following tables and data to the database. Use the appropriate field types ...

Oracle databaseusing the schema you developed in homework 1

Oracle Database Using the Schema you developed in Homework 1 for your e-Commerce project, design and implement a Virtual Private Database that limits database access. Your design should be based on two of your columns an ...

Benefits of data protection controlsbased on what you have

Benefits of Data Protection Controls Based on what you have learned about data protection in an online environment, prepare a 5-slide presentation to a department head or the CEO of a company to convince the audience tha ...

Assignmentproject descriptionextreme h2o is a company that

Assignment Project Description: Extreme H2O is a company that specializes in water sports. It is considering adding some new experiences for its customers. In a nearby community, there is a small river that can be used f ...

Assignmentyou are to design a program that will serve as a

Assignment You are to design a program that will serve as a database for keeping track of video games and various statistics for the games. This application will allow for the storing of the name of a video game, its gen ...

Ngocbo database projectthe purpose of this project is to

NGO/CBO Database Project The purpose of this project is to build a database to store and retrieve basic information on NGOs/CBOs collected through a questionnaire given in the Appendix. Database Specifications In view of ...

Relational database systems comp 1005objective this is an

Relational Database Systems (COMP 1005) Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scen ...

Frontlines united states of secrets all Frontline's United States of Secrets, all

Frontline's United States of Secrets, all episodes: http://www.pbs.org/wgbh/frontline/film/united-states-of-secrets/ (Links to an external site.) Nova's Genome specials http://www.pbs.org/wgbh/nova/body/cracking-the-code ...

Create a small bank account database with one account table

Create a small Bank Account database with one Account table. The Account table Should have fields for account number, customer last and first names, and current balance. The type of database will be Access .Populate the ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen