Last answered:

14 Aug 2023

Posted on:

05 Aug 2023

0

why this one not working

SELECT m.title ,  d.hire_date , d.first_name , d.last_name 
FROM titles m 
 JOIN
employees d on m.emp_no = d.emp_no
WHERE  d.first_name= ' margareta' AND d.last_name= 'markowitch' 

1 answers ( 0 marked as helpful)
Instructor
Posted on:

14 Aug 2023

0

Hi Mustafa!
Thanks for reaching out.


You should remove the whitespace at the beginning of the first name and use Markovitch instead of Markowitch. Your query should be:

SELECT 
    m.title, d.hire_date, d.first_name, d.last_name
FROM
    titles m
        JOIN
    employees d ON m.emp_no = d.emp_no
WHERE
    d.first_name = 'Margareta'
        AND d.last_name = 'Markovitch';


Hope this helps.
Best,
Tsvetelin

Submit an answer