Home / Answered Questions / Other / find-the-skill-name-and-the-number-of-agents-with-that-skill-for-the-skill-posessed-by-the-most-agen-aw685
(Solved): Find The Skill Name And The Number Of Agents With That Skill, For The Skill Posessed By The Most Age...
Find the skill name and the number of agents with that skill, for the skill posessed by the most agents.
skillrel skill id agent id skill skill_id skill
We have an Answer from Expert View Expert Answer
Table Design create table skillrel(skill_id number(4),agent_id number,primary key(skill_id,agent_id)); desc skillrel; insert into skillrel values(101,201); insert into skillrel values