w3resource

AdventureWorks Database: Contacts designated as a manager

SQL Query - AdventureWorks: Exercise-19 with Solution

19. From the following table write a query in SQL to find the contacts who are designated as a manager in various departments. Returns ContactTypeID, name. Sort the result set in descending order.

Sample table: Person.ContactType


Click to view Full table

Sample Solution:

SELECT ContactTypeID, Name
    FROM Person.ContactType
    WHERE Name LIKE '%Manager%'
    ORDER BY Name DESC;

Sample Output:

contacttypeid|name                           |
-------------+-------------------------------+
           19|Sales Manager                  |
           15|Purchasing Manager             |
           13|Product Manager                |
            8|Marketing Manager              |
            6|International Marketing Manager|
            1|Accounting Manager             |	

SQL AdventureWorks Editor:

Practice Online


Contribute your code and comments through Disqus.

Previous: Specify which groups to include in the results.
Next: List contacts who are Purchasing Manager.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Share this Tutorial / Exercise on : Facebook and Twitter

SQL: Tips of the Day

T-SQL Cast versus Convert?

CONVERT is SQL Server specific, CAST is ANSI.

CONVERT is more flexible in that you can format dates etc. Other than that, they are pretty much the same. If you don't care about the extended features, use CAST.

Ref : https://bit.ly/3VKT5M8