Week 3 Graded Quiz :Managing Big Data with MySQL (Excel to MySQL: Analytic Techniques for Business Specialization) Answers 2025

Answer Key

1. Type of join (Table A & B)
   ✔ Inner Join
   ❌ Left Join, Right Join, Full Outer Join

2. Type of join (Table A & B)
   ✔ Right Join
   ❌ Inner Join, Left Join, Full Outer Join

3. Average rating for “yawn warm-up” and “yawn game”
   ✔ 0.96 and 2.94
   ❌ Other options

4. Activity types with different number of unique user ids and dog ids
   ✔ 2
   ❌ 167, 18, 0, 2044

5. Subcategories in exam_answers with total loop numbers >100,000
   ✔ 12
   ❌ 30, 1, 3, 2

6. Sorting in retail sales query
   ✔ By style in descending alphabetical order
   ❌ Total sum of sales, brand, department, etc.

7. COUNT vs COUNT(*) results
   ✔ Query A: 450,251; Query B: 450,551
   ❌ Other options

8. Complete_tests but NOT in reviews, completed 40 tests
   ✔ 87
   ❌ 52, 222, 199, 34

9. Unique mixed breed dogs that completed “Emotions” test
   ✔ 4,125
   ❌ 832, 7,299, 36,221, 2,022

10. Top 5 states for unique human users completing “Puzzles” in 2015
    ✔ CA, TX, FL, IL
    ❌ N/A

11. Unique dogs in site_activities vs reviews
    ✔ site_activities but not reviews: 24,839; reviews but not site_activities: 5,596
    ❌ Other options

12. Changes to SELECT clause for query to execute
    ✔ servings → AVG(servings) or MAX(servings)
    ✔ course → COUNT(course) or COUNT(DISTINCT course)
    ✔ author → COUNT(author) or COUNT(DISTINCT author)
    ❌ AVG(calories → calories, add cuisine)

13. Shih Tzu dogs weighing 190 lbs
    ✔ # distinct dogs: 182; average tests: 10.2; min: 0; max: 20
    ❌ Other options

14. Breed completing most tests (only breeds ≥10 dogs)
    ✔ Breed: Shih Tzu; maximum tests completed: 45
    ❌ Other options

Summary Table: SQL Joins & Advanced Queries Quiz