Blog

What is this query doing:SELECT *, CASE WHEN default_account_number = 172 THEN “good”   WHEN default_account_number = 145 THEN “defaulted”     WHEN default_account_number = 307 THEN “defaulted”     WHEN default_account_number = 367 THEN “good”     WHEN default_account_number = 456 THEN “good”  END AS delays_goodFROM vendors; 

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

What is the result of this query? SELECT *, IF(vendor_state regexp “IL” and vendor_contact_last_name regexp “John”, “Yes”, “No”) AS il_to_trackFROM vendors;

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

Which query would run on the following view and will get the count of all vendors not from “CA” and not from “MI”:create view view_SA3 ASSELECT *FROM vendorsWHERE vendor_state NOT IN (“CA”,”MI”);

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

  What is the name of the fleshy membranous structure indicated by the arrow?

  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