Resolved: Duplicate tasks in Task 1 and Task 2

in SQL / Introduction to JOINs

Hello,

I just want to clarify if this assignment really intends to insert the dept_name 'Public Relations' twice.

Thanks,
Carl

1 answers ( 1 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

07 Sept 2022

Hi Carl!
Thanks for reaching out.

You just need to insert it one time. Then, delete the department with number = 'd002'. Finally, insert two new records in the departments_dup table with values: 'd010' and 'd011'.

Hope this helps.
Best,
Tsvetelin

Helpful answer

Submit an answer

related questions

Islam Elkhateeb

Resolved: can't add row, I do may trail and it all back with errors

Alessandro Imbrìaco

Resolved: Explanations to questions 15 and 29

Marcus Wern Han Leong

Why did you not do not null, primary key and auto increment for customer id in the solution?

Archisman Das

Resolved: SQL Task- getting the names of all the managers who have an AVG salary of 85k+

Nourhan Osama Ahmad

how to upload the assignment and remark on it

Maxime Darbouze

I wrote the same command that is the sql file and it did not work

Maxime Darbouze

1681 Integer display width is deprecated and will be removed in a future release.

Kiran B

Resolved: Queries with LIKE('Mar%') and LIKE('Mar_') are returning the output with 1000 rows each

Islam Elkhateeb

Resolved: Fixed Number of Row retrieved from each of my between and And query

Kshitij Yende

Resolved: Values asked for both IN and OUT Parameter

Saurav Bharali

Resolved: Joins and Duplicate records

Sam Parker

Resolved: How can I Download MySQL Server and Workbench on a Mac?