Question: Create a table using SQL (job_id, name, age, salary, sex, DOB)and insert the values using insert command then write a PLISQL query to show

Create a table using SQL (job_id, name, age, salary, sex, DOB)and insert

Create a table using SQL (job_id, name, age, salary, sex, DOB)and insert the values using insert command then write a PLISQL query to show the salary of the each person from the table and display. Output: Salary of James is 78000 Salary of Martin is 100000 Salary of Minakshi is 75000 Salary of Rajnish is 62000

Step by Step Solution

★★★★★

3.36 Rating (146 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

SQL create a table CREATE TABLE employee jobid INTEGER PRIMARY KEY name TEXT NOT NULL age I... 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 Computer Engineering Questions!

Write an SQL command to display each item ordered for order number 1, its standard price, and the total price for each item ordered.

Write an SQL command to display the order number, customer number, order date, and items ordered for some particular customer.

Create a SQL query to satisfy each of the tasks below. Save each SQL query using the name associated with the task in the table below You must create an sql code for each tasks and ensure when...

The management of JustLee Books has submitted two requests. The first is for a mailing list of all customers stored in the CUSTOMERS table. The second is for a list of the percentage of profit...

Consider an employee database with two relations employee (employee-name, street, and city) works (employee-name, company-name, salary) where the primary keys are underlined. Write a query to find...

Daniel, age 38, is single and has the following income and expenses in 2014. Salary income .................................................................. $60,000 Net rent income...

Daniel, age 38, is single and has the following income and expenses in 2016. Salary income ......................................................................$60,000 Net rent income...

Daniel, age 38, is single and has the following income and expenses in 2015. Salary income .......................................................... $60,000 Net rent income...

In this problem, you will use your knowledge of the phase plane and stability to analyze a simple model of glycolysis. The glycolysis pathway that first convert glucose into fructose-6-phosphate...

Imagine the type of workplace or organization where you see yourself practicing technical communication in the future, and envision situations to which you might apply this chapter's heuristic. How...

Despite significant advances, inequities still exist, and sometimes stunningly discriminatory actions still occur. The contemporary system does a better job now of addressing and resolving these...

Lodrobe Company manufactures a single product: wardrobes. Lodrobe's wardrobes have a unique design that is not replicated by any other wardrobe manufacturer. The company was formed at the beginning...

Do a brief research on the following Act Language. Identify the contributions of those it in language development. Place the link/s at the very end or bottom. 1. Ministerial Memorandum No. 523,p....

A satellite is in circular orbit 525 km above the surface of Earth. Determine the satellite's speed A satellite is in circular orbit 525 km above the surface of Earth. Determine the satellite's speed

EXHIBITS Income Statement exhibits close all Income Statement CPA Bakers Inc., a calendar year S corporation, is a retailer of gourmet snacks located in Happyville, U.S. CPA Bakers' current year...

ces This problem is based on the transactions for the Eco Build Company in your text. Prepare journal entries for each transaction and identify the financial statement impact of each entry. The...

EcoSacks manufactures cloth shopping bags. The controller is preparing a budget for the coming year and asks for your assistance. The following costs and other data apply to bag production: You learn...

Is the modified 5-question approach to ethical decision making superior to the modified moral standards or modified Past in approach?

Consider Figure 1-14. Explain the meaning of the line that connects CUSTOMER to ORDER and the line that connects ORDER to INVOICE. What does this say about how Pine Valley Furniture Company does...

Figure 4-36 includes an EER diagram describing a car racing league. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such...

Each semester, each student must be assigned an adviser who counsels students about degree requirements and helps students register for classes. Each student must register for classes with the help...

The adjusted trial balance of Reid and Campbell Ltd. at December 31, 2017, appears below. Requirements 1. Prepare Reid and Campbell Ltd.'s 2017 income statement, statement of retained earnings, and...

On May 31, 2016, Nancy Thomas borrowed $6,000 from Assiniboine Credit Union. Thomas signed a note payable, promising to pay the credit union principal plus interest on May 31, 2017. The interest rate...

Perform the following accounting for the receivables of Benoit, Brown & Hill, an accounting firm, at December 31, 2017. 1. Start with the beginning balances for these T-accounts: Accounts...