Skip to content

Instantly share code, notes, and snippets.

View sunyuding's full-sized avatar

YuDing Joseph Sun sunyuding

View GitHub Profile
@sunyuding
sunyuding / README.md
Created August 10, 2019 17:31 — forked from leonardofed/README.md
A curated list of AWS resources to prepare for the AWS Certifications


A curated list of AWS resources to prepare for the AWS Certifications

A curated list of awesome AWS resources you need to prepare for the all 5 AWS Certifications. This gist will include: open source repos, blogs & blogposts, ebooks, PDF, whitepapers, video courses, free lecture, slides, sample test and many other resources.


@sunyuding
sunyuding / employees_department.sql
Created August 14, 2019 05:45
Hacker Rank MySQL Employees by department excercise
/*
Hacker Rank MySQL Employees by department excercise
Write a query to print the respective Department Name and total of employees per department for all departments in Department table
Include departments with 0 employees.
Order the results per total of employees, if 2 or more departments have the same amount of employees then order alphabetically by department name
*/
SELECT DEPARTMENT.NAME, COUNT(EMPLOYEE.ID) AS COUNT_OF_EMPLOYEES_IN_THE_DEPARTMENT
FROM DEPARMENT