Breaking News: Grepper is joining You.com. Read the official announcement!

coderbyte sql solutions

olanrewaju sule-balogun answered on March 18, 2021 Popularity 1/10 Helpfulness 1/10

answer coderbyte sql solutions

coderbyte sql solutions

Comment

SELECT base_table_name.ID, base_table_name.Name, DivisionName, CASE WHEN base_table_name.ManagerID IS NOT NULL AND base_table_name.ManagerID = base_table_name.ID
then Name ELSE 'Susan Wall' END AS 'ManagerName', salary
FROM base_table_name  
left join cb_companydivisions on maintable_8V9LH.DivisionId = cb_companydivisions.id

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Mar 01 2022

olanrewaju sule-balogun

0 Answers Avg Quality 2/10

Closely Related Answers

coderbyte sql solutions

Comments(1)

In this MySQL challenge, your query should return all the people who report to either Jenny Richards or have a NULL value in ReportsTo. The rows should be ordered by Age. Your query should also add a column at the end with a title of Boss Title where the value is either None or CEO. Your output should look like the following table.

Popularity 6/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Mar 18 2021

Horrible Herring

0 Answers Avg Quality 2/10

coderbyte sql solutions

Comments(1)

In this MySQL challenge, your query should return the information for the employee with the third highest salary. Write a query that will find this employee and return that row, but then replace the DivisionID column with the corresponding DivisionName from the table cb_companydivisions. You should also replace the ManagerID column with the ManagerName if the ID exists in the table and is not NULL.

Popularity 1/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql

Link to this answer
Share Copy Link

Contributed on Oct 04 2021

Elegant Echidna

0 Answers Avg Quality 2/10

coderbyte sql solutions

Contents

More Related Answers

coderbyte sql solutions

Closely Related Answers

coderbyte sql solutions

coderbyte sql solutions

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.