SQL Project #6 – IS 201 Discussion Forum

Questions Archive › Category: Questions › SQL Project #6

Rachel Simmons asked 3 years ago

For the SQL project question #6, this is what I put down. Does this look right? It says to use the COUNT feature. How do I know if all encounters are being accounted for?
SELECT COUNT(purchase)
FROM encounter

WHERE purchase = FALSE

1 Answers

0 Vote Up Vote Down

Shayna O. answered 3 years ago

The only way to know if all encounters are being accounted for is if you count all the records individually. If you think you’re doing the query right, you’re probably doing it right. This question is very straightforward.

Your Answer