Coderbyte sql solutions

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.

Coderbyte sql solutions

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.

Similar codes

1 vote256 views1 answer
Oracle lock user
SQL
0 vote281 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote252 views1 answer
Mysql show foreign keys column
SQL
-1 vote256 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote280 views4 answers
First max salary in sql
SQL
0 vote286 views1 answer
Offset in postgresql example
SQL
3 votes244 views2 answers
Having in mysql
SQL
1 vote470 views1 answer
Postgres convert text to number
SQL
1 vote266 views1 answer
Insert column after column mysql
SQL
5 votes246 views1 answer
List foreign key oracle
SQL