The result of this query will containSELECT vendor_name, COUNT(*) AS number_of_invoices,      AVG(invoice_total – payment_total – credit_total) AS max_balance_dueFROM vendors v  JOIN invoices i ON v.vendor_id = i.vendor_id WHERE invoice_total – payment_total – credit_total

How many groups will this statement create and what is the group size for 121 customers? NTILE(6) OVER (ORDER BY SUM(TotalAmount)) AS AvgGroup  

After running this query, what is the result?SELECT vendor_state, vendor_city, vendor_name, COUNT(*) AS invoice_quantity,   SUM(invoice_total) AS invoice_total_overallFROM invoices JOIN vendors   ON invoices.vendor_id = vendors.vendor_idWHERE vendor_state  REGEXP “M”GROUP BY vendor_state, vendor_city, vendor_nameHAVING SUM(invoice_total)

If you run this query, the result table will contain one row for SELECT i.vendor_id, MIN(i.invoice_total) AS smallest_invoiceFROM invoices i    JOIN      (SELECT vendor_id, AVG(invoice_total) AS average_invoice     FROM invoices     GROUP BY vendor_id     HAVING AVG(invoice_total)

A hygienist is treating a patient who has active periodontal disease to preserve teeth and periodontal tissues. What principle is she applying? 

A hygienist withholds information from a patient because of her belief that the information may be harmful to the individual. What principle is she violating?

The death of a patient must be reported to whom and in what period of time?

All of the following except one, are duties regulated under direct supervision. Which one is the exception?

In which of the following situations may a RDH provide sealants and fluoride “without supervision”

If you are awarded a probationary license, what is the term?