We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Advanced Select
- New Companies
- Discussions
New Companies
New Companies
Sort by
recency
|
3239 Discussions
|
Please Login in order to post a comment
Check out this video for 10 Solved SQL Hackerrank Solutions - https://www.youtube.com/watch?v=sUMUDJUWDZI
Compiler isnt working correctly even if you paste the correct solution!
Check out this video for 10 Solved SQL Hackerrank Solutions - https://www.youtube.com/watch?v=sUMUDJUWDZI
select c.company_code, c.founder, count(distinct(e.lead_manager_code)), count(distinct(e.senior_manager_code)), count(distinct(e.manager_code)), count(distinct(e.employee_code)) from company c join employee e on c.company_code = e.company_code group by c.company_code, c.founder order by c.company_code asc;
Why does everyone keep using c.company_code instead of Company.company_code?
Is this deliberate to shorten the code or am I not understanding the table names?