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 vote163 views1 answer
Import all databases mysql
SQL
0 vote182 views1 answer
Oracle query to find schema you are working on
SQL
1 vote177 views1 answer
How to update date add hours in postgresql
SQL
0 vote174 views1 answer
Difference between db.query and db.execute
SQL
0 vote175 views1 answer
How to write if case in select query in select statement
SQL
0 vote173 views1 answer
Postgresql isnull with max
SQL
4 votes185 views2 answers
Mysql delete user if exists
SQL
1 vote167 views1 answer
Sql current timestamp
SQL
2 votes200 views1 answer
Select a certain number of entries from select mysql
SQL
1 vote175 views1 answer
Sqlite create index
SQL