Blog

Download the Grades.xlsx Excel file and complete the four tasks described in the document.  Save the file and upload the updated Excel file to this question.   

I have thoroughly reviewed the Honorlock guidelines and acknowledge each directive.  By proceeding with this assessment, I affirm my committment to adhere to all Honorlock policies and directions for this assessment.  I understand that any violation of these guidelines will result in receiving a zero for this assessment. 

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 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_amount descending)

Question: Management wants to review products from international suppliers (not from USA) that are priced under $100 OR are in the ‘Sports’ or ‘Accessories’ categories. Write the query to show product and supplier details.  Display: product_name, category, unit_price, supplier_name, country (sorted by country ascending, unit_price descending)  

The sonographer changes the transducer from a 3 MHz to a 6 MHz transducer but does not change the imaging depth. Which of the following will remain unchanged?

How many elements of a phased array probe with 100 elements are excited simultaneously?

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

Which of these probes does NOT produce a sector image 

Which imaging modality places dots of dissimilar gray scale on the display a) A b)B c) M d) PW