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

0 vote243 views0 answer
SQL
0 vote284 views1 answer
Postgres execute multiple sql file from command line
SQL
5 votes267 views6 answers
Sql add days to date
SQL
0 vote283 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
18 votes295 views6 answers
Creating table in MySQL
SQL
2 votes318 views1 answer
Select a certain number of entries from select mysql
SQL
4 votes367 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote281 views1 answer
Sql not exists
SQL
0 vote295 views2 answers
Oracle select
SQL
0 vote301 views1 answer
Delete duplicate rows
SQL