Write a query to display first name, last name and department number of employees who work in department 300 or have the title CLERK 1.
Added by Virginia I.
Step 1
Step 1: Identify the tables involved We will need to use the employees table to retrieve the first name, last name, department number, and title of employees. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 98 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Determine the department name, department manager, and department phone number of HELEN TRUJILLO, employee number 83465. Include in the query output June's last name and number and her manager's last name, department, and phone.
Akash M.
EMP_NUM EMP_LNAME EMP_FNAME SAL_AMOUNT 83746 RANKIN SEAN 95550.00 84328 CARPENTER FERN 94090.00 83716 RIVERA HENRY 85920.00 84432 JAMISON MERLE 85360.00 83902 VARGAS ROCKY 79540.00 83695 MENDEZ CARROLL 79200.00 84500 WESTON CHRISTINE 78690.00 84594 TIDWELL ODELL 77400.00 83910 AVERY LAUREN 76110.00 83359 WATTS MERLE 72240.00
1. Write an SQL query to fetch the no. of workers for each department in the descending order.
Muhammad J.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD