1. Home
  2. Discussions
  3. CertNexus
  4. Certified AI Practitioner
  5. AIP-210 Discussions
  6. AIP-210 Exam Topic 3 Question 25 Discussion

CertNexus Certified Artificial Intelligence Practitioner (CAIP) AIP-210 Question # 25 Topic 3 Discussion

 CertNexus Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

CertNexus Certified Artificial Intelligence Practitioner (CAIP) AIP-210 Question # 25 Topic 3 Discussion

AIP-210 Exam Topic 3 Question 25 Discussion:
Question #: 25
Topic #: 3

Below are three tables: Employees, Departments, and Directors.

Employee_Table

AIP-210 Question 25

Department_Table

AIP-210 Question 25

Director_Table

ID

Firstname

Lastname

Age

Salary

DeptJD

4566

Joey

Morin

62

$ 122,000

1

1230

Sam

Clarck

43

$ 95,670

2

9077

Lola

Russell

54

$ 165,700

3

1346

Lily

Cotton

46

$ 156,000

4

2088

Beckett

Good

52

$ 165,000

5

Which SQL query provides the Directors' Firstname, Lastname, the name of their departments, and the average employee's salary?
A.

SELECT m.Firstname, m.Lastname, d.Name, AVG(e.Saiary) as Dept_avg_SaiaryFROM Employee_Table as eLEFT JOIN Department_Table as d on e.Dept = d.NameLEFT JOIN Directorjable as m on d.ID = m.DeptJDGROUP BY m.Firstname, m.Lastname, d.Name

B.

SELECT m.Firstname, m.Lastname, d.Name, AVG(e.Salary) as Dept_avg_SalaryFROM Employee_Table as eRIGHT JOIN Departmentjable as d on e.Dept = d.NameINNER JOIN Directorjable as m on d.ID = m.DeptJDGROUP BY d.Name

C.

SELECT m.Firstname, m.Lastname, d.Name, AVG(e.Salary) as Dept_avg_SalaryFROM Employee_Table as eRIGHT JOIN Department_Table as d on e.Dept = d.NameINNER JOIN Directorjable as m on d.ID = m.DeptJDGROUP BY e.Salary

D.

SELECT m.Firstname, m.Lastname, d.Name, AVG(e.Salary) as Dept_avg_SalaryFROM Employee_Table as eRIGHT JOIN Department_Table as d on e.Dept = d.NameINNER JOIN Directorjable as m on d.ID = m.DeptIDGROUP BY m.Firstname, m.Lastname, d.Name

Get Premium AIP-210 Questions
Actual exam question for CertNexus AIP-210 exam by Eris1652 at Oct 18, 2025, 9:19:40 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next