8 kyu
Easy SQL - Ordering
20,951 of 20,957PG1
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 | 23309 |
| Total Skips | 667 |
| Total Code Submissions | 31054 |
| Total Times Completed | 20957 |
| SQL Completions | 20951 |
| Total Stars | 51 |
| % of votes with a positive feedback rating | 92% of 2337 |
| Total "Very Satisfied" Votes | 2018 |
| Total "Somewhat Satisfied" Votes | 276 |
| Total "Not Satisfied" Votes | 43 |
| Total Rank Assessments | 77 |
| Average Assessed Rank | 7 kyu |
| Highest Assessed Rank | 3 kyu |
| Lowest Assessed Rank | 8 kyu |
