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 votes152 views2 answers
Update all rows mysql
SQL
6 votes169 views3 answers
Check if string contains substring sql
SQL
0 vote154 views1 answer
Alter table myisam to innodb
SQL
0 vote217 views1 answer
Sql server is not
SQL
0 vote146 views2 answers
How to set global time_zone in mysql
SQL
0 vote156 views1 answer
Can we rollback deleted data in sql
SQL
2 votes152 views1 answer
Plsql block
SQL
0 vote176 views2 answers
How to see table associated with a schema in sql
SQL
1 vote178 views1 answer
Load mysql dumb
SQL
4 votes152 views2 answers
Select first and last row mysql
SQL