I’m stuck on the 3rd query for this assignment. I put in what I think it the write SQL and it keeps giving me errors. I watched the videos and readings but can’t seem to figure out what I’m doing wrong. Is there something I’m missing that someone can help explain to me?
This is my current SQL code:
SELECT cfirstname, clastname, annualincome
FROM customer
inner join salesperson on customer.customerid= salesperson.customerid
where annualincome >80000 AND sfirstname = “Katie”