Solution:Step 1: List rows from both tablesEmployees1 has (1, Alice), (2, Bob), (3, Carol). Employees2 has (2, Bob), (3, Carol), (4, Dave).Step 2: Find common rowsCommon rows are those present in both: (2, Bob) and (3, Carol).Final Answer:Rows with Bob and Carol only -> Option AQuick Check:INTERSEC

[Solved] Given two tables:Employees1:id | name1 | Alice2 | Bob3 | CarolEmployees2:id | name2 | Bob3 | Carol4 | DaveWhat is the result of this query?... | SQL

SQL - Set Operations

SELECT id, name FROM Employees1 INTERSECT SELECT id, name FROM Employees2;

ARows with Bob and Carol only

BRows with Alice, Bob, Carol, and Dave

CRows with Alice only

DRows with Dave only

Step-by-Step Solution

Solution:

Step 1: List rows from both tables
Employees1 has (1, Alice), (2, Bob), (3, Carol). Employees2 has (2, Bob), (3, Carol), (4, Dave).
Step 2: Find common rows
Common rows are those present in both: (2, Bob) and (3, Carol).
Final Answer:
Rows with Bob and Carol only -> Option A
Quick Check:
INTERSECT returns common rows = Bob, Carol [OK]

Quick Trick: INTERSECT returns only rows present in both tables [OK]

Common Mistakes:

MISTAKES

Including rows unique to one table
Confusing UNION with INTERSECT
Ignoring column matching in rows

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given two tables:

Step 1: List rows from both tables

Step 2: Find common rows

Final Answer:

Quick Check:

Want More Practice?