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

13 votes186 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote190 views1 answer
Sql server update top n records
SQL
0 vote192 views1 answer
Sql check if column exists
SQL
0 vote204 views1 answer
Drop specific row postgresql
SQL
2 votes192 views2 answers
Sql lag
SQL
0 vote235 views1 answer
Postgres row expiration
SQL
0 vote176 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote197 views1 answer
Oracle create program if no exists
SQL
0 vote208 views1 answer
How to see the query of a view in mysql
SQL
7 votes188 views1 answer
Mysql iif
SQL