SQL

iriadna hernandez asked 1 year ago

SELECT cfirstname, clastname, annualincome
FROM customer
WHERE annualincome > 80000
This is what I have for question three so far but I have no clue how to add “who purchased cars from salesperson “katie”

1 Answers
Shayna answered 1 year ago

You’ll have to think about several things:
1) which column and table can the name ‘Katie’ be found?
2) is that table already connected to the customer table, or do you have to make any joins to connect the two tables together?
3) what kind of condition do you have to add to query people who purchase cars from sales person Katie?
If you have any other questions, feel free to come into the TA lab or hop onto the virtual lab. Good luck!

Your Answer

14 + 12 =

css.php