The statement CREATE VIEW view_sa3ASSELECT *FROM vendorsWHERE vendor_state NOT IN (“CA”,”MI”,”WI”,”AZ”);

The statement CREATE VIEW view_sa3ASSELECT vendor_name, AVG(invoice_total) AS avg_of_invoicesFROM vendors JOIN invoices ON vendors.vendor_id = invoices.vendor_idGROUP BY vendor_nameHAVING AVG(invoice_total)>21ORDER BY vendor_name;

When this query is executed, the result set will contain SELECT vendor_name, COUNT(*) AS number_of_invoices,        AVG(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) >=     (SELECT AVG(invoice_total – payment_total – credit_total)     FROM invoices) GROUP BY vendor_name ORDER BY balance_due DESC;

When this query is executed, 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) >=88) vendors_temp   ON i.vendor_id = vendors_temp.vendor_idGROUP BY i.vendor_idORDER BY smallest_invoice;

Extra Credit: How much WATER will you add to make 1.5L of 10% stock solution, if the stock solution is 100%?  mLs

When you use WHERE in a query, code in the WHERE part

A dentist may legally discontinue treatment of a patient 

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

If elder abuse occurs in a long term care facility who is it reported to?

_____________ are instruments that are not used to penetrate tissue or bone but contact oral mucosa