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;

How many groups will this statement create and what is the group size for 101 customers?NTILE(5) OVER (ORDER BY Avg(TotalAmount) DESC) AS AvgGroup  

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_dueFROM 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_nameORDER BY number_of_invoices, balance_due DESC; 

  What is the number for tooth “M” according to the triadan numbering system?

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

Carla is a 3 yr old female dog that cut herself along a fence and needs to be anesthetized for a wound repair. She weighs 48lbs. She was already given a premedication. Your doctor asks you to draw up propofol at 2mg/kg for her. You look at the propofol bottle and it says 10mg/mL. How much propofol do you draw up. Round to the nearest 10th. (one decimal) and only write the number. mLs

  What class malocclusion is this?

Tessa is a 5 yr old Yorkshire Terrier that presented with dehydration and severe bloody diarrhea. She is 7.5 lbs. Your doctor asks you to calculate out IV metronidazole at 15mgs/kg for her. You look on the bag of metronidazole and it says 5mg/mL. How much metronidazole will you give Tessa? Round to the nearest 10th (one decimal place) and only write the number. mLs

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”);