Question: 2. Create and run an SQL statement that displays the columns containing first names, last names, job ids, and salaries and also an additional column

2. Create and run an SQL statement that displays the columns containing first names, last names, job ids, and salaries and also an additional column that multiplies the salary column by 12. In the output, make sure the new salary column (the salary multiplied by 12) is labeled as: Modified Salary

3. Write an SQL statement that subtracts 20 from the salary column and then multiples that result by 5 creating a new column (this subtracts 20 from everyones salary and then multiples their salary by 5).Write an SQL statement that subtracts 20 from the salary column and then multiples that result by 5 creating a new column (this subtracts 20 from everyones salary and then multiples their salary by 5).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 General Management Questions!

1. Create and run an SQL query that will return/display the first names, email, last names and job identifications of employees from the EMPLOYEES table and the department identifications and...

Homework # 4 Instructions Log into your Oracle liveSQL account and open and run the Bookstore database script. Then write and run the following queries: Query 1 : Write and run an SQL statement to...

6 . Write the SQL statement to create a report with employee employee ids, last names, job id , phone numbers, and salary for all employees who make at least $ 8 , 0 0 0 AND their job id is IT _...

Please help with this lab assignment - Java Chapter 16 Lab - Databases Lab Objectives Be able to write SQL statements. Be able to retrieve information from a database. Be able to add information to a...

Please help me with code not how to use NetBEAN. Can help make the code work and help me to compile and to RUN Is note how to use NetBean I need help with CODE PLEASE Thank I can Run if the Code work...

Chapter 17 Lab Databases Lab Objectives Be able to write SQL statements. Be able to retrieve information from a database. Be able to add information to a database. Be able to change information in...

2. Run the SQL statement that would display the first names, last names, and the hire dates for the following employees: Ellen Abel, Amit Banda, and Harrison Bloom (this report must contain this...

Part 1 Maintaining and redesigning an existing database Create the following schema for maintaining the books issued to the patrons. books ( book_id int, title varchar(20), author_last_name...

The question is for introduction to database system with sql live. The assignmemt is due on tomorrow 12p.m. Part 1 Maintaining and redesigning an existing database Create the following schema for...

I would greatly appreciate any help on this, this is an assignment in MySQL. Thank you in advance! 1) Faculty has decided to give all staff members a 5% raise. Create output as shown: Faculty id,...

Although not presented in the chapter, the POPAI Consumer Buying Habits Study revealed that the percentage of in-store decisions for coffee was 57.9 percent, whereas the comparable percentage was...

How do collars, the hedge ratio, the protective call, and the protective put help investors manage risk?

The balances of select accounts of Sandra Company as of December 3 1 , 2 0 1 8 are given below: \ begin { tabular } { | l | l | l | } \ hline & Debit & Credit \ \ \ hline Building & \ $ 1 4 0 , 0 0 0...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...