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

4 votes184 views1 answer
What are the data types in sql
SQL
0 vote247 views1 answer
Double in sql server example
SQL
0 vote184 views1 answer
Vowels in sql
SQL
0 vote186 views1 answer
Sql get month from date
SQL
0 vote198 views1 answer
How to add timestamp column in mysql
SQL
3 votes193 views1 answer
Oracle drop user
SQL
5 votes208 views2 answers
Oracle list columns
SQL
2 votes228 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote265 views1 answer
Selecting specific day in colum sql
SQL
1 vote188 views1 answer
Right outer vs left outer join
SQL