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 votes238 views1 answer
Postgres upsert
SQL
1 vote280 views1 answer
Oracle datafile max size 32gb
SQL
2 votes277 views2 answers
How to check data type in sql server
SQL
0 vote350 views1 answer
How to rename a database in tsql
SQL
0 vote278 views1 answer
Show table details postgresql
SQL
6 votes279 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
8 votes269 views2 answers
Oracle auto increment primary key
SQL
4 votes264 views4 answers
Sqlite describe table
SQL
-1 vote273 views1 answer
Sql set max value in column
SQL
0 vote297 views3 answers
Condition in count sql
SQL