8 kyu
Easy SQL - Ordering
21,291 of 21,297PG1
Description:
Your task is to sort the information in the provided table 'companies' by number of employees (high to low). Returned table should be in the same format as provided:
companies table schema
- id
- ceo
- motto
- employees
Solution should use pure SQL. Ruby is only used in test cases.
Fundamentals
SQL
Similar Kata:
Stats:
| Created | Jun 12, 2017 |
| Published | Jun 12, 2017 |
| Warriors Trained | 23691 |
| Total Skips | 677 |
| Total Code Submissions | 31511 |
| Total Times Completed | 21297 |
| SQL Completions | 21291 |
| Total Stars | 52 |
| % of votes with a positive feedback rating | 92% of 2360 |
| Total "Very Satisfied" Votes | 2037 |
| Total "Somewhat Satisfied" Votes | 280 |
| Total "Not Satisfied" Votes | 43 |
| Total Rank Assessments | 77 |
| Average Assessed Rank | 7 kyu |
| Highest Assessed Rank | 3 kyu |
| Lowest Assessed Rank | 8 kyu |
