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

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

We have an Answer from Expert
Buy This Answer $6

-- OR --

Subscribe To View Unlimited Answers
Subscribe $20 / Month