Q1 Write the SQL statement to display employee names, designation and cities of those employees whose designation starts with M and ends with R and whose salary is greater than 2500 Q2 Display the following results Write the SQL statement to display the hire days of all employees (All days must come in one column) Write the SQL statement to ROUND OFF all the salaries up to 2 decimal places

Question: Q1.Write the SQL statement to display employee names, designation and cities of those employees whose designation starts with M and ends with R and whose

Q1.Write the SQL statement to display employee names, designation and cities of those employees whose designation starts with “M” and ends with “R” and whose salary is greater than 2500.

Q2.Display the following results:

Write the SQL statement to display the hire days of all employees (All days must come in one column). 
Write the SQL statement to ROUND OFF all the salaries up to 2 decimal places.

Step by Step Solution

★★★★★

3.41 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

SELECT name designation city F... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q1. Write the SQL statement to display the ids, names, job names and salaries of all employees in descending order by minimum salary. Q2. Write the SQL statement to insert a new column named...

Write an SQL statement to display all data on products having a QuantityOnHand greater than 0.

Write an SQL statement to display WarehouseID.

1. A restaurant, Pizza of Gaithersburg, Inc. (PG), agreed with Virginia Coffee Service (VCS) to have vending machines installed in PGs restaurants. The contract was to run for one year and was...

Please read the case study and answer thequestions that follow. SOUTHWEST AIRLINES HIRES SERVICE-MINDED,FUN-LOVING INDIVIDUALS Southwest Airlines began flying with justfour planes in 1971 and has...

Which method of work flow is embodied in Autolivs system? Video Case Lean Systems at Autoliv Autoliv is a world-class example of lean manufacturing. This Fortune 500 company makes automotive safety...

Autoliv is a world-class example of lean manufacturing. This Fortune 500 company makes automotive safety components such as seat belts, airbags, and steering wheels, and has over 80 plants in more...

Q1. Write the SQL statement to display the employee id, employee name and city of those employees whose designation is Manager and annual (yearly) commission is greater than 4000. (hint: the given...

In business organisations, as elsewhere, success tends to breed success. However, a growing sense of corporate self-confidence can breed problems of its own. How does a company prevent pride in its...

a. Borrowed $72,000 from the bank, with C. Zertoc signing a note payable in the name of the business. Journal Entry Date Debit Credit a. Cash 72,000 Note Payable 72,000 Borrowed cash on note payable....

Describe the effect of a series or shunt input connection on the value of input resistance.

What is meant by the term matched transistors? What parameters in BJTs and MOSFETs are identical in matched devices?

What is one cause of an offset voltage in the input stage of a BJT op-amp?

Using the data in the table below, calculate the project schedule variance units: Schedule Variance Work Units A B C D E Total Planned Value (PV) 30 25 10 15 40 120 Earned Value (EV) 25 15 5 15 30...

What are the attributes of a technical decision?

Tina Domingo owns a car stereo store. She has divided her store into three departments. Net sales for the month of July are as follows: Deluxe: $36,000 Standard: 30,000 Economy: 54,000 Advertising...

You work as an operations consultant for a textile company. Your client has a well-established distribution system in the US market. The company has hundreds of stores and four distribution centers....

Why is a database considered to be self-describing?

Name three vendors of DBMS products.

Explain how the PL/SQL statement FOR variable IN cursorname works.

The Ecco Company makes electronics products for distribution throughout the world. As a member of the quality department, you are interested in the warranty claims that are made by customers who have...

The Vilmore Corporation is considering two word-processing programs for its PCs. One factor that will influence its decision is the ease of use in preparing a business report. Consequently, Jody...

Required Tasks: 1. Identify the major issues in the case. 2. Identify an appropriate statistical analysis to perform. 3. Explain why you selected the test you choose in (2). 4. State the appropriate...