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:
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 eg customert
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 eg customert
Hint: Q is an extension of Q you can use a subquery as a new column in SELECT clause of the solution to Q Should it be a simple or correlated subquery?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
