BuyFindarrow_forward

Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
ISBN: 9781337627900

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
ISBN: 9781337627900
Textbook Problem

Write the SQL code that will produce the same information that was shown in Problem 2, but sorted by the employee’s last name.

Program Plan Intro

Join:

Join is a relational operation, which combines the data from two or more tables into single table or view, then that is called as Join.

ORDER BY Clause:

SQL contains “ORDER BY” clause in order to sort rows. The values get sorted in ascending as well as descending order. The keyword used to sort values in ascending order is “ASC” and for descending order is “DESC”. By default, it sorts values by ascending order.

Syntax:

SELECT column_Name1, column_Name2 FROM table_Name ORDER BY column_Name2;

Program Explanation

SQL code:

The SQL code to join the tables “EMPLOYEE” and “PROJECT” using “EMP_NUM” as the common attribute is given below:

SELECT PROJ_NAME, PROJ_VALUE, PROJ_BALANCE, EMP_LNAME, EMP_FNAME, EMP_INITIAL, JOB.JOB_CODE, JOB_DESCRIPTION, JOB_CHG_HOUR FROM PROJECT JOIN EMPLOYEE ON PROJECT.EMP_NUM = EMPLOYEE.EMP_NUM JOIN JOB ON EMPLOYEE.JOB_CODE = JOB...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Additional Engineering Solutions

Find more solutions based on key concepts

Show solutions add

What is structural independence, and why is it important?

Database Systems: Design, Implementation, & Management

Describe the World Wide Web and how it works.

Fundamentals of Information Systems

What two line types work together to show sizes on an engineering drawing?

Precision Machining Technology (MindTap Course List)

What do the terms organizational culture and organizational learning mean?

Principles of Information Systems (MindTap Course List)

Explain what is meant by an isometric drawing.

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)