Follow this topic

NEDJMEDDINE BENBOUZID

Last answered:

03 Dec 2021

Posted on:

15 Nov 2021

0

'departments_dup' table doesn't exist

in SQL / Another Example of Using COALESCE()

'departments_dup' table doesn't exist so the query mentioned in the solution couldn't run, the action output table in MYSQL displayed an Error.

1 answers ( 0 marked as helpful)

Instructor

Posted on:

03 Dec 2021

0

Hi Nedjmeddine!

Тhanks for reaching out!

It seems that you have not created the table departments_dup. Please, create it and then run the query.

Hope this helps.
Best,
Martin

Submit an answer

related questions

Sivarajan Sivakumar

0

14

Cannot insert 999903 into the dept_emp table?

Harsha Dharmabandu

1

14

Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty

5

12

Resolved: M query fetch time increased after creating an index for the salaries table!

Christopher Watts

1

12

Error Code: 1364. Field 'customer_id' doesn't have a default value

Francois Chouinard

1

10

Can you show the instructions to reproduce dept_manager_dup table?

Ashakah Onome Andrew

0

10

Resolved: Salaries table is empty, showing Null

0

10

Drop table from the database

0

10

Error after Error: Can't create a table this time