Question

Finding Duplicate Actors Notes Code Problem Your task is to write an SQL query that finds all entries in the Actor table where the first_name and last_name are the same as another actor's first and last names. For example: +----------+------------+-----------+ | actor_id | first_name | last_name | +----------+------------+-----------+ | 1 | JOHN | APPLESEED | | 22 | JOHN | APPLESEED | | 32 | MARK | ZUCKERBERG | | 44 | MARK | ZUCKERBERG | +----------+------------+-----------+ (4 rows) Your query's result table must contain these columns: 1. actor_id; 2. first_name; and 3. last_name. The results should be listed in alphabetical order by first_name and last_name, then in increasing order by actor_id for actors with the same names. Try to use SQL's CROSS JOIN operator in your answer! Film film_id title description length release_year rental_duration rental_rate replacement_cost rating special_features language_id original_language_id Film_Actor film_id actor_id Actor actor_id first_name last_name nationality Country country_id short_code name Film_Category film_id category_id Category category_id name parent_cat Language language_id name Overview of the tables in the film database schema.

          Finding Duplicate Actors
Notes
Code
Problem
Your task is to write an SQL query that finds all entries in the Actor table where the first_name and last_name are the same as another actor's first and last names. For example:

+----------+------------+-----------+
| actor_id | first_name | last_name |
+----------+------------+-----------+
| 1 | JOHN | APPLESEED |
| 22 | JOHN | APPLESEED |
| 32 | MARK | ZUCKERBERG |
| 44 | MARK | ZUCKERBERG |
+----------+------------+-----------+
(4 rows)

Your query's result table must contain these columns:
1. actor_id;
2. first_name; and
3. last_name.

The results should be listed in alphabetical order by first_name and last_name, then in increasing order by actor_id for actors with the same names.

Try to use SQL's CROSS JOIN operator in your answer!

Film
film_id
title
description
length
release_year
rental_duration
rental_rate
replacement_cost
rating
special_features
language_id
original_language_id

Film_Actor
film_id
actor_id

Actor
actor_id
first_name
last_name
nationality

Country
country_id
short_code
name

Film_Category
film_id
category_id

Category
category_id
name
parent_cat

Language
language_id
name

Overview of the tables in the film database schema.

Finding Duplicate Actors
Notes
Code
Problem
Your task is to write an SQL query that finds all entries in the Actor table where the firstname and lastname are the same as another actor's first and last names. For example:

+———-+————+———–+
| actorid | firstname | lastname |
+———-+————+———–+
| 1 | JOHN | APPLESEED |
| 22 | JOHN | APPLESEED |
| 32 | MARK | ZUCKERBERG |
| 44 | MARK | ZUCKERBERG |
+———-+————+———–+
(4 rows)

Your query's result table must contain these columns:
1. actorid;
2. firstname; and
3. lastname.

The results should be listed in alphabetical order by firstname and lastname, then in increasing order by actorid for actors with the same names.

Try to use SQL's CROSS JOIN operator in your answer!

Film
filmid
title
description
length
releaseyear
rentalduration
rentalrate
replacementcost
rating
specialfeatures
languageid
originallanguageid

FilmActor
filmid
actorid

Actor
actorid
firstname
lastname
nationality

Country
countryid
shortcode
name

FilmCategory
filmid
categoryid

Category
categoryid
name
parentcat

Language
languageid
name

Overview of the tables in the film database schema.

Added by Felix B.

Question

Please give Ace some feedback