Recent Lessons

Show all results for ""

12 Questions

0 Views

Master SQL JOIN

Choose a study mode

Play Quiz

Study Flashcards

Spaced Repetition

Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which type of JOIN returns all records when there is a match in either the left or right table, as well as unmatched records from both tables?

FULL OUTER JOIN (correct)
INNER JOIN
RIGHT JOIN
LEFT JOIN

Which type of JOIN returns records that have matching values in both tables?

FULL OUTER JOIN
INNER JOIN (correct)
RIGHT JOIN
LEFT JOIN

What does a LEFT OUTER JOIN return?

All records from the right table and the matched records from the left table
None of the above
All records when there is a match in either left or right table
All records from the left table and the matched records from the right table (correct)

What is the purpose of a JOIN clause in SQL?

To combine rows from two or more tables based on a related column between them (A) Signup and view all the answers

Which type of JOIN returns all records from the left table, and the matched records from the right table?

LEFT OUTER JOIN (B) Signup and view all the answers

What is the purpose of a JOIN clause in SQL?

To combine rows from two or more tables based on a related column between them (D) Signup and view all the answers

What type of JOIN returns records when there is a match in either left or right table?

INNER JOIN (D) Signup and view all the answers

What does a RIGHT OUTER JOIN return?

All records from the right table, and the matched records from the left table (D) Signup and view all the answers

Which of the following aggregate functions can be used with the GROUP BY statement in SQL?

AVG() (B) Signup and view all the answers

Which of the following SQL statements will list the number of customers in each country, sorted from low to high?

SELECT Country, COUNT(CustomerID) FROM Customers GROUP BY Country ORDER BY Country ASC; (C) Signup and view all the answers

Which of the following is NOT an aggregate function in SQL?

AVERAGE() (C) Signup and view all the answers

Which of the following SQL statements will list the number of orders sent by each shipper, sorted alphabetically by shipper name?

SELECT Shippers.ShipperName, COUNT(Orders.OrderID) AS NumberOfOrders FROM Orders LEFT JOIN Shippers ON Orders.ShipperID = Shippers.ShipperID GROUP BY ShipperName ORDER BY Shippers.ShipperName ASC; (A) Signup and view all the answers

Master SQL JOIN

Choose a study mode

Podcast

Questions and Answers

Which type of JOIN returns all records when there is a match in either the left or right table, as well as unmatched records from both tables?

Which type of JOIN returns records that have matching values in both tables?

What does a LEFT OUTER JOIN return?

What is the purpose of a JOIN clause in SQL?

Which type of JOIN returns all records from the left table, and the matched records from the right table?

What is the purpose of a JOIN clause in SQL?

What type of JOIN returns records when there is a match in either left or right table?

What does a RIGHT OUTER JOIN return?

Which of the following aggregate functions can be used with the GROUP BY statement in SQL?

Which of the following SQL statements will list the number of customers in each country, sorted from low to high?

Which of the following is NOT an aggregate function in SQL?

Which of the following SQL statements will list the number of orders sent by each shipper, sorted alphabetically by shipper name?

More Like This

Master the Essential SQL Commands

Master SQL Fundamentals

Master SQL Query Keywords

Master SQL with this Data Manipulation Quiz!