SQL Subqueries

SQL Subqueries

Assessment

Flashcard

Computers

University

Practice Problem

Hard

Created by

Riddhish Thakore

Used 1+ times

FREE Resource

Student preview

quiz-placeholder

19 questions

Show all answers

1.

FLASHCARD QUESTION

Front

What SQL query retrieves employees working in companies located in Hyderabad?

Back

SELECT ename FROM employee e WHERE EXISTS (SELECT 1 FROM company c JOIN city ct ON c.lid = ct.lid WHERE c.cid = e.cid AND ct.lname = 'Hyderabad');

2.

FLASHCARD QUESTION

Front

How can you find companies that have at least one employee?

Back

SELECT cname FROM company c WHERE EXISTS (SELECT 1 FROM employee e WHERE e.cid = c.cid);

3.

FLASHCARD QUESTION

Front

What is the SQL query to get employees working for companies located in cities with more than one company?

Back

SELECT ename FROM employee e WHERE EXISTS (SELECT 1 FROM company c1 WHERE c1.cid = e.cid AND EXISTS (SELECT 1 FROM company c2 WHERE c1.lid = c2.lid AND c1.cid <> c2.cid));

4.

FLASHCARD QUESTION

Front

How do you find cities that have employees working in any company located there?

Back

SELECT lname FROM city ct WHERE EXISTS (SELECT 1 FROM company c JOIN employee e ON c.cid = e.cid WHERE c.lid = ct.lid);

5.

FLASHCARD QUESTION

Front

What query retrieves employees not assigned to any company?

Back

SELECT ename FROM employee e WHERE NOT EXISTS (SELECT 1 FROM company c WHERE c.cid = e.cid);

6.

FLASHCARD QUESTION

Front

How can you find companies that don’t have any employees?

Back

SELECT cname FROM company c WHERE NOT EXISTS (SELECT 1 FROM employee e WHERE e.cid = c.cid);

7.

FLASHCARD QUESTION

Front

What is the SQL query to get cities with no companies?

Back

SELECT lname FROM city ct WHERE NOT EXISTS (SELECT 1 FROM company c WHERE c.lid = ct.lid);

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?