When this query is executed, the rows will be sorted by SELECT vendor_name, COUNT(*) AS number_of_invoices,        MAX(invoice_total – payment_total – credit_total) AS balance_due FROM vendors v   JOIN invoices i   ON v.vendor_id = i.vendor_id  WHERE invoice_total – payment_total – credit_total

Which query would run on the following view and will count all vendors from “CA” or “Michigan”:create view my_view_SA2 ASSELECT *FROM vendorsWHERE vendor_state IN (“CA”, “MI”);

The statement CREATE VIEW my_view_sa2ASSELECT vendor_name, MAX(invoice_total) AS max_of_invoicesFROM vendors JOIN invoices ON vendors.vendor_id = invoices.vendor_idGROUP BY vendor_nameHAVING MAX(invoice_total)>199ORDER BY vendor_name;

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?