Beta
SQL Data: Company Data - totals per day
239matt c
Description:
Your task is simple, given the data you must calculate on each day how many hours have been clocked up for each department.
Tables and relationship below:
Resultant table:
- day (date) [order by]
- department_name (name of department) [order by]
- total_hours (total hours for the day)
SQL
Fundamentals
Data Science
Similar Kata:
Stats:
| Created | Oct 30, 2016 |
| Published | Oct 30, 2016 |
| Warriors Trained | 894 |
| Total Skips | 138 |
| Total Code Submissions | 2111 |
| Total Times Completed | 239 |
| SQL Completions | 239 |
| Total Stars | 16 |
| % of votes with a positive feedback rating | 87% of 120 |
| Total "Very Satisfied" Votes | 91 |
| Total "Somewhat Satisfied" Votes | 27 |
| Total "Not Satisfied" Votes | 2 |
| Total Rank Assessments | 112 |
| Average Assessed Rank | 6 kyu |
| Highest Assessed Rank | 4 kyu |
| Lowest Assessed Rank | 8 kyu |
