Write an SQL query for the HAPPY INSURANCE database that will, for each agent, retrieve the name of the agent and the name of his or her supervisor. (The name of the agent will be retrieved even if he or she has no supervisor.)
What will be an ideal response?
SELECT a.agentname, s.agentname
FROM agent a LEFT OUTER JOIN agent s
ON a.supervisedby = s.agentid;
You might also like to view...
Which of the following is not a reason why group or team members typically enforce norms?
A. to clarify role expectations B. to help the group survive C. to create a written document of behavioral guidelines for new employees D. to emphasize the group's important values E. to help individuals avoid embarrassing situations
Which of the following is true of moral imagination?
A. It distinguishes good people who make ethically responsible decisions from good people who do not. B. It occurs when decision makers fail to notice gradual variations over time. C. It refers to the positive impact a hypothetical decision is projected to have on the stakeholders involved in the decision. D. It denotes reasonable ethical judgments that a person makes without regard for facts.
Refer to Oakland Athletics. Beane’s subordinates respect the general manager’s abilities, trust him to do what his best for the team, and like him as a person. In terms of situational favorableness, Beane’s leadership ability is influenced by ____.
A. strong position power B. empowerment C. low task structure D. weak position power E. good leader-member relations
________ was sued by the Justice Department for violating antitrust laws in connection with e-books.
A. Amazon B. Google C. Apple D. Barnes & Noble