Question: Consider the table below and answer the questions that follow. Table 3: staffilst 4.1 Create a query to view each employee's wage as well as

Consider the table below and answer the questions that follow. Table

Consider the table below and answer the questions that follow. Table 3: staffilst 4.1 Create a query to view each employee's wage as well as what it would be if you added 5000 to it. (5 Marks) 4.2 In September Andrew received 11764.658 because of some deductions from his wage. Implement CEILING and FLOOR functions on SQL developer to round the amount (11764.658) to a nearest whole number. (5 Marks) 4.3. Let the output from CEILING be ' y ' and output from FLOOR be ' x '. Is y>x ? Explain your answer. (5 Marks) 4.4 Assume you want to combine the name and salary value of an employee (Johnson) from the stafflist table (concatenation). Create SQL query to perform the operation. Keep a space between the name and wage. (5 Marks) 4.5 Assume you have been assigned the responsibility of extracting the last three characters from the Stafflist table's name field. Is it possible to run this query without utilizing the LENGTH function

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!

SQL Functions A function is a piece of code stored in the database that allows you to perform a specific task that returns an output. There are a lot of functions built into Oracle SQL to perform a...

Crashing Construction Project Schedules by Relocating Resources Construction projects constitute a particular challenge for managers. The factors that contribute to their unpredictability include the...

4.1. Define the following: 4.1.1. Repo rate (1) 4.1.2. Monetary policy (1) 4.1.3. Labour force (1) 4.1.4. Gross domestic expenditure (GDE) (1) 4.2. Define and provide two (2) arguments against and...

This Is the relationship Need to write a SQL Query F,G,and H in a SQL Assignment This is a simplified version of the Access Workbench Exercise in the textbook. Follow along in the textbook for more...

QBE Queries: Using Microsoft Access QBE, create and run new queries to answer the questions that follow. Save each query using the query name format QBEQuery-#, where the # sign is replaced by the...

I am having problems with the QBE G query. It does not display all of the employees for each project, instead it only displays one employee for every project. QBE Queries: Using Microsoft Access QBE,...

Need Some help for The D and E queries for this animal table ANIMAL (AnimalID, NickName, Species, Sex, Age, Exhibit , Keeper ) EXHIBIT (ExhibitName, Environment) KEEPER (KeeperID, LastName,...

I need help with three differnt querys for this animal table A,B,And C ANIMAL (AnimalID, NickName, Species, Sex, Age, Exhibit , Keeper ) EXHIBIT (ExhibitName, Environment) KEEPER (KeeperID, LastName,...

A conservatively financed firm would A. use long-term financing for all fixed assets and short-term financing for all other assets. B. finance a portion of permanent assets and short-term assets with...

How large a surface area in units square feet will 1 gallon of paint cover if we apply a coat of paint that is 0.1 centimeter thick?

Briefly describe the concept of sampling efficiency and discuss the ways in which it could be improved.

Question 7 : What is the most important task in computer security based on cryptography?

Any negligence of the part of the plaintiff is a complete bar to recovery in: Group of answer choices a comparative negligence state a contributory negligence state a concurrent negligence state a...

Technology. Six months ago, you entered into a one-year contract with Waldos Fitness Center. In the past two months, much of the equipment has not been working properly. In addition, many days the...

As ticket manager for Help Me, Donnie, a popular new TV talk show, prepare a form letter to be sent to people who have requested and will receive tickets to the show. In addition to basic information...

Club members will handle publicity, security, setup, and cleanup; no one will have access to the building.As the companys facility manager, approve Brendas request.Waive the $150 facility-use fee...