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

2 votes397 views3 answers
Sql delete duplicate
SQL
0 vote331 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
2 votes312 views1 answer
How to select first row of database sql
SQL
24 votes357 views5 answers
List mysql users
SQL
0 vote357 views1 answer
How to move a columns location in mysql
SQL
0 vote350 views3 answers
Fetlife
SQL
0 vote321 views1 answer
Psql not found windows
SQL
0 vote351 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote319 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
1 vote365 views1 answer
Nvl postgres
SQL