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 votes307 views1 answer
Oracle list duplicates
SQL
37 votes287 views3 answers
Postgresql insert column
SQL
1 vote288 views2 answers
Mysql insert generate serie
SQL
0 vote292 views1 answer
Get relation data in mysql using query to excel
SQL
2 votes295 views1 answer
How to get weekday from old date in sql
SQL
32 votes308 views6 answers
Sql count where
SQL
0 vote288 views2 answers
Find lowest number in sql
SQL
0 vote285 views1 answer
Mysql update privileges
SQL
0 vote322 views1 answer
Mysql record group by created date count
SQL
1 vote281 views1 answer
Get url of cpanel database hostname
SQL