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 votes197 views1 answer
Oracle list grants on procedure
SQL
21 votes207 views4 answers
Oracle add column
SQL
9 votes218 views3 answers
Mysql run sql file
SQL
0 vote217 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote214 views1 answer
Psql generate id in existing database
SQL
0 vote194 views1 answer
Sql remove non numeric characters
SQL
5 votes185 views1 answer
Update sql user password
SQL
2 votes226 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote198 views1 answer
Time in sql server
SQL
0 vote212 views1 answer
Create database like
SQL