Question: With the information provided above, how would you write a SQL code on DBeaver for this problem statement below? Step 1: Show first name, last

With the information provided above, how would you write a SQL

code on DBeaver for this problem statement below? Step 1: "Show first

name, last name, salary and birthday of managers whose salary is greater

With the information provided above, how would you write a SQL code on DBeaver for this problem statement below?

Step 1: "Show first name, last name, salary and birthday of managers whose salary is greater than 51000 and birthday is after "1970-01-01"

Hint: for the "after" in birthday criteria, use greater than symbol ">" "

__________

Step 2: "Then show how the company will make a salary increase for managers whose salary is less than 60 and never received a bonus. The salary increase is 15%. Show eligible people's last name, current salary and salary amount after the increase.

Hint: Use "IS NULL" to see if the bonus variable has NULL value."

__________

Thank you in advance!

(2) DBeaver 22300 - manaqer File Edih Navigate Serarth SQl Editot Database Wirduw Help

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 Databases Questions!

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

Copy the following questions. Then, go to DBeaver, right click on hafh database, SQL Editor, New SQL Script. In the blank window, paste these questions. You will be writing SQL queries against hafh...

I need help with my assignment I am supposed to use command prompt and sequel for it There are three tasks in this assignment: A) create tables , B) insert data , and C) c omplete queries. For each...

Level 1 1. Using the %UPCASE and %SCAN Functions a. Open m103p01.sas from the practices folder. Add a %LET statement to convert the value of FullName to uppercase and assign the result to FullName....

5. Create the following SQL queries using Select in the query window. Comment each step in the script. Each task must use a subquery. A. Plant the code below in your script commented as 5A-1. SELECT...

1. Your company uses 2 tables to store product information named LocalProducs and InternationalProducts. You also use a table named Orders that stores open order information. You must retrieve the ID...

Adobe Acrobat Mrs. Wu comes to you for advice in February 2021. Last year 2020, was a year of considerable change and turmoil for her. Her job in Montreal, Quebec, with X Ltd. was finished because of...

*Lab 6 is there in case you don't know what "Lab 7" instructions are referring to when they say" Lab 6." Lab 7 is the one that needs to be done. Lab 7: Inserting and Updating Data OVERVIEW This lab...

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

Task 1 ( 1 0 pts ) : Executing all SQL scripts in " hw 4 db . sql " to create four tables and have the corresponding data inserted. What to submit: - Four screenshots of executing the following SQL...

A 40-year maturity bond has a 6% coupon rate, paid annually. It sells today for $1,017.42. A 30-year maturity bond has a 6.5% coupon rate, also paid annually. It sells today for $1,009.5. A bond...

Electrons are accelerated through a potential difference of 38.0 V. The beam of electrons then passes through a single slit. The width of the central fringe of a diffraction pattern formed on a...

1 . Exactly two months ago, the value of your retirement account was $ 5 0 0 , 0 0 0 . Today, its value has decreased to $ 4 9 1 , 0 0 0 . What was its two - month simple return? What was its...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

Explain why a sender should use short paragraphs in business messages. Tell what the average length of short paragraphs should be for (a) letters and memos and (b) reports. (Objective 3)

Give sentences unity. Rewrite the following long sentences making them concise and understandable. If needed, divide the content into more than one sentence to express only one main thought in each...

Use appropriate nontechnical words. Use an online or print dictionary to select nontechnical words to replace each of these technical words: (a) dividend, (b) prosthesis, (c) equity, (d) hypothesis,...