SQL Topic and Exam elaborations

9.	9. The SQL command WHERE does which of the following?

a.	Indicates the tables to be used in the query

b.	Lists the names of the fields to be displayed on the screen

c.	Limits the records to only those meeting the test condition(s)

d.	All of the above: c. Limits the records to only those meeting the test condition(s)

10.	10. Why will these two queries return different averages?



SELECT AVG(unitprice - unitcost) FROM cts
Test Bank Digital Fundamentals, 11th edition by Floydd
ODP Contact Lens Final Exam
ODP Contact Lens Final Exam
College Physics 10th Edition Serway Test bank
ODP Contact Lens Final Exam