Write a SQL query to provide information to help with the following decision: the product team wants to understand Silver membership customers’ interest in Sports products. They want to identify all Silver members who have purchased products in the Sports category. Display: customer_name, city, product_name, purchase_amount, purchase_date (sorted by purchase_date ascending)

Write the SQL query to create a report showing region name, number of unique customers, total revenue from purchases, number of unique products purchased, and average purchase amount per region. This will guide regional marketing strategies. (10 points) Display: region_name, unique_customer_count, total_revenue, unique_products_purchased, avg_purchase_amount (sorted by total_revenue descending)  

Write the SQL query to help the finance team that needs a quarterly sales breakdown for 2024. Show total sales, number of purchases, and average purchase amount for each quarter. (10 points) Display: quarter_number, total_sales, number_of_purchases, avg_purchase_amount (sorted by quarter)  

The total distance traveled when the time from the probe and back to the probe is 78 microsecs is

What the transmitted intensity if an incident intensity of 60mw/cm^2 is incident at an interface between 2 media with an angle of 90 degrees, , the impedances of Medium 1 and 2 are equal, and no gel is used for a scan?

A sound beam emitted by a probe returned after 39 microseconds. What is the depth to the reflector?

All of these describe  image resolution EXCEPT

What happens to the resonant frequency of a PW probe if element thickness is doubled?

What are the effects of focusing?  

  V2-C3,C4&C5 Summative-Oct 25.pdf   Data Booklet.pdf