In the SQL query below, the Teacher table is the $\_\_\_\_\_.$

SELECT LastName, FirstName, CourseTitle

FROM Teacher

INNER JOIN Class

ON Teacher.TeacherID $=$ Class.TeacherID;

Group of answer choices

Left table

Right table

Source table

Main table

Flag question: Question $2$

Question $21$ pts

Refer to the tables below. Which join completes the SQL query and produces the result table below?

SELECT CourseTitle, FirstName, LastName

FROM Class

$\_\_\_\_\_$ Teacher

ON Class.TeacherID $=$ Teacher.TeacherID;

Teacher

TeacherID LastName FirstName

$11234$ Lopez Rosa

$45631$ Wilson Maggie

$32412$ McNeal Bryan

Class

$$ClassID CourseCode CourseTitle

TeacherID

$12$ HTML$1$ Web Development $32412$

$30$ DB$1$ Databases $11234$

$56$ PROG$1$ Programming $11234$

$80$ MATH$26$ Algebra NULL

Result

CourseTitle FirstName LastName

Web Development Bryan McNeal

Databases Rosa Lopez

Programming Rosa Lopez

Algebra NULL NULL

Group of answer choices

FULL JOIN

RIGHT JOIN

LEFT JOIN

INNER JOIN

Flag question: Question $3$

Question $31$ pts

Refer to the tables below. Which join completes the SQL query and produces the result table below?

SELECT CourseTitle, FirstName, LastName

FROM Class

$\_\_\_\_\_$ Teacher

ON Class.TeacherID $=$ Teacher.TeacherID;

Teacher

TeacherID LastName FirstName

$11234$ Lopez Rosa

$45631$ Wilson Maggie

$32412$ McNeal Bryan

Class

$$ClassID CourseCode CourseTitle

TeacherID

$12$ HTML$1$ Web Development $32412$

$30$ DB$1$ Databases $11234$

$56$ PROG$1$ Programming $11234$

$80$ MATH$26$ Algebra NULL

Result

CourseTitle FirstName LastName

Web Development Bryan McNeal

Databases Rosa Lopez

Programming Rosa Lopez

NULL Maggie Wilson

Group of answer choices

RIGHT JOIN

INNER JOIN

FULL JOIN

LEFT JOIN

Flag question: Question $4$

Question $41$ pts

What is wrong in the following query?

SELECT Sales.OrderID, Customer.FirstName, Customer.LastName

FROM Sales

INNER JOIN Customer

ON CustomerID $=$ CustomerID;

Group of answer choices

The Customer table does not appear in the FROM clause.

Nothing is wrong in the query.

The columns in the SELECT clause are in the wrong order.

The CustomerID prefix is missing.

Flag question: Question $5$

Question $51$ pts

A database administrator wants to correlate pairs of rows from the same table. Which type of join should the database administrator use?

Group of answer choices

Cross$-$join

Self$-$join

Left join

Full join