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

5 votes162 views3 answers
Select tables from mysql database
SQL
5 votes151 views3 answers
Bash: mysql: command not found
SQL
0 vote136 views1 answer
Python mysql query where
SQL
0 vote137 views2 answers
Sqlite unix timestamp
SQL
1 vote172 views1 answer
How not to sort by average rating
SQL
0 vote340 views1 answer
Redirection 301 htaccess nom de domaine
SQL
1 vote152 views1 answer
Mysql select if empty result
SQL
0 vote141 views4 answers
Forenkey code alchemy sql
SQL
0 vote157 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote175 views1 answer
Mysql best varchar length size
SQL