Question: using the database ( in the image ) , answer the following questions: 1 . Find the employees who have more than one skill. Show

using the database (in the image), answer the following questions:
1. Find the employees who have more than one skill.
Show employeeName and skillDescription.
Sort the results based on employeeName, then by skillDescription.
You need to append '_t' to the end of your tablenames (e.g. customer_t)
2. Find the employees who have more than one skill.
Show employeeName, skillDescription, and the number of skills that this employee has.
Sort the results based on employeeName, then by skillDescription.
You need to append '_t' to the end of your tablenames (e.g. customer_t)
Hint: Q2 is an extension of Q1, you can use a subquery as a new column in SELECT clause of the solution to Q1. Should it be a simple or correlated subquery?
 using the database (in the image), answer the following questions: 1.

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!