Blog

Management wants a category-level sales summary. Write a query showing for each product category:category, total_products_sold, total_revenue, avg_purchase_amount, highest_purchase total_products_sold = total quantity sold across all purchases total_revenue = sum of all purchase amounts avg_purchase_amount = average purchase amount highest_purchase = the single largest purchase amount in that category Sorted by total_revenue descending. Table: products, purchases

Write the SQL query to provide information for this analysis: For customers who made purchases in April or May 2024, calculate how many days it has been since their last purchase (use Dec 31, 2024 as the reference date). This will help identify customers for re-engagement campaigns Display: customer_id, last_purchase_date, days_since_purchase (sorted by last_purchase_date ascending) Tables: purchases

In the following figure of a sarcomere during muscle relaxation, what do the numbers 1, 2, and 3 correspond to respectively?

The calcium facilitating contraction of a skeletal myofiber comes from:

Tetanus occurs as a result of:

If a person has no antigens on their red blood cells and both anti-A and anti-B antibodies in their plasma, what is their blood type?

The primary function of hemoglobin is to:

Which of the formed elements in blood are responsible for clotting?

Which of the following do cardiac contractile and skeletal muscle fibers have in common?

The A band corresponds to the length of: