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

Assignmentas the new manager of a convenience store you

Assignment As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items c ...

1 how are qbe tools and sql similar2 how are they

1. How are QBE tools and SQL similar? 2. How are they different? 3. What is a data warehouse? 4. How does it differ from a database?

Analytical assignment individual or group of max two

Analytical Assignment (Individual or Group of Max two students) What is Research article? Review articles provides summary of current state of the research on a particular topic. Ideally, the writer searches for everythi ...

Discussionyou have been asked to help a critical

Discussion You have been asked to help a critical infrastructure company in analyzing the privacy and security of a SCADA system. Conduct research on the topic and answer the following: 1. How would you describe general ...

A task descriptionoverviewyour task is to create and test a

A. Task Description Overview Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, describing the requirements that Southern Cross University may ...

Database analysis and designimplement the initial database

Database Analysis and Design Implement the initial database design for the Enterprise Resource Planning conceptual model described by the following requirements in your selected RDBMS. You need to create the Entity-Relat ...

Data warehouse1 review the submission hokie resort

Data Warehouse 1. Review the submission Hokie Resort situation description to understand the problem domain(see Business Situation Description below) 2. Write the three most important questions that management must answe ...

Question 1use the tables below to answer the following

Question 1: Use the tables below to answer the following questions: customerid customerid firstname lastname city state 10101 John Gray Lynden Washington 10298 Leroy Brown Pinetop Arizona 10299 Elroy Keller Snoqualmie Wa ...

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 ...

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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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