Blog

  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

You doctor asks you to make 50mL of 1% NaCl from a stock solution of 2% NaCl by diluting it with sterile water. How much water do you add to the stock solution? mLs

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

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;

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

What is this query doing:SELECT vendor_id, CASE WHEN default_account_number = 452 THEN “green”   WHEN default_account_number = 440 THEN “red”     WHEN default_account_number = 303 THEN “green”     WHEN default_account_number = 472 THEN “red”     WHEN default_account_number = 294 THEN “red”  END AS delay_flagsFROM vendors;

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

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