Associate Data Analyst Certification Exam - Stuck on Task 4
I just gave the exam today and got through all the tasks except Task 4. IMHO, it was one of the easier ones. I'm wondering if they want a more complex solution. The task is straightforward
"The team want to look in more detail at meat and dairy products where the average units sold was greater than ten. Write a query to return the product_id, price and average_units_sold of the rows of interest to the team."
I did a simple SELECT statement for the 3 variables from the "products" table with a WHERE clause to filter for Meat or Dairy product type AND average_units_sold greater than 10. During submission, it showed me an error along the lines of "not displaying all the required data". Please help. What am I missing here?
If you need help, visit our website: hiraedu. com or whatsApp: +12136359834 or connect via info in pinned comment below!
Posted Jun 28, 2026, 10:17 PM UTC