Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Charles Chung

Language: Layout:
absolute service time: 0,42 sec 
edit mode |  history  | discussion
   mysql version
1 5.7.12-log
   id job_position name salary
1 1 software developer Company A 110000
2 2 software architect Company A 130000
3 3 QA Analyst Company A 55000
4 4 software engineer Company B 70000
5 5 electric engineer Company C 75000
6 6 qa analyst Company C 75000
   id name hobby work_id
1 1 Eric Skiing 3
2 2 Stewart Music 2
3 3 Nancy Sailing 1
4 4 Jen Sailing 1
5 5 Paul Music 4
6 6 Dan Music 5
   name hobby job_position name salary
1 Nancy Sailing software developer Company A 110000
2 Jen Sailing software developer Company A 110000
3 Stewart Music software architect Company A 130000
4 Eric Skiing QA Analyst Company A 55000
5 Paul Music software engineer Company B 70000
6 Dan Music electric engineer Company C 75000
   name count(p.name)
1 Company A 4
2 Company B 1
3 Company C 1
   job_position
1 qa analyst
   hobby avg(salary)
1 Music 91666,6667
2 Sailing 110000,0000
3 Skiing 55000,0000