SQL Project Query #3

Questions ArchiveCategory: QuestionsSQL Project Query #3
Beatriz asked 2 years ago

So far, I have done this 

SELECT cfirstname, clastname, annualincome
FROM creditrating
INNER JOIN customer ON creditrating.creditid = customer.creditid
INNER JOIN encounter ON customer.customerid = encounter.customerid
INNER JOIN salesperson ON encounter.salesid = salesperson.salesid
WHERE annualincome >=80000
AND sfirstname = ‘Katie’

 
but how can I make sure that the customer purchased from Katie?
how do you link PURCHASE?

1 Answers
Justis answered 2 years ago

there’s a purchase column in encounter, that would be a good place to look

Your Answer

18 + 15 =

css.php