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 votes160 views1 answer
Mysql auto increment jumping
SQL
0 vote231 views1 answer
Postgres rename database
SQL
0 vote176 views1 answer
Timestamp(0) postgresql
SQL
3 votes184 views1 answer
Force using index plsql
SQL
0 vote167 views4 answers
Mysql desactivar trigger
SQL
4 votes215 views1 answer
Rename stored procedure in sql server
SQL
4 votes202 views2 answers
Insert current date in mysql
SQL
1 vote188 views1 answer
Postgresql datetrunc too slow
SQL
0 vote169 views1 answer
Select all tables linked server sql
SQL
0 vote184 views1 answer
Casterar postgres
SQL