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

0 vote130 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote123 views1 answer
Sql server list table sizes
SQL
5 votes128 views1 answer
How to get all table names in sql query
SQL
3 votes146 views1 answer
How to get yesterday date in sql
SQL
0 vote122 views3 answers
How to assign custom id in mysql
SQL
8 votes99 views3 answers
Duplicate entry
SQL
0 vote145 views1 answer
Set classpath for mysql-connector.jar
SQL
1 vote120 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
6 votes121 views2 answers
Mysql 1 day ago
SQL
0 vote115 views1 answer
Increase speed of like queries postgres
SQL