Skip to content

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

Answer Key

  1. Required keywords to retrieve data
    ✔ SELECT, FROM
    ❌ WHERE, ORDER (BY), GROUP (BY), HAVING

  2. What causes the query to crash
    ✔ Comma after “amt” in the first line
    ❌ Other options

  3. Interpretation of LIMIT 20,25
    ✔ Output the values in the “name” column from 25 rows of data in table “RootBeerBrand”, starting with row 21
    ❌ Other options

  4. View column names in a table
    ✔ SHOW and COLUMNS
    ❌ DESCRIBE + HELP/TABLES, SHOW + TABLES

  5. Plausible number of rows for SELECT DISTINCT company, snack_type
    ✔ 35,333
    ❌ 657, 4888, 50,555, 50,000

  6. Number of columns in “reviews” table NOT permitting NULL
    ✔ 3
    ❌ 1, 2, 4, 7

  7. dog_guid entries in exam_answers with NULL values
    ✔ 6,442
    ❌ 12, 0, 1,229, 9,005

  8. Earliest start_time in exam_answers
    ✔ 2013-02-05 01:02:55
    ❌ Other options

  9. Unique dogs played Eye Contact Game between June 1, 2014 – June 1, 2015
    ✔ 6,822
    ❌ 5,813, 4,847, 14,785, 12,048

  10. Unique combinations of user ids and activity types in site activities
    ✔ 1,353,130
    ❌ 1,553,256, 59,356, 48,212, 79,787

  11. Unique dogs >10 lbs with “poodle” in breed
    ✔ 788
    ❌ 717, 967, 659, 823

  12. Weight of first dog after sorting breed DESC, dog_guid ASC
    ✔ 50
    ❌ 20, 30, 40, 100

Summary Table: SQL & Dognition Database Quiz

Q# Topic Answer / Key Insight
1 Required SQL keywords SELECT, FROM
2 Query syntax error Comma after last column
3 LIMIT clause interpretation 25 rows starting row 21
4 View columns SHOW + COLUMNS
5 DISTINCT query output 35,333 rows
6 Columns NOT NULL 3 columns
7 NULL dog_guid 6,442 entries
8 Earliest start_time 2013-02-05 01:02:55
9 Unique Eye Contact Game dogs 6,822 dogs
10 Unique user_id + activity combinations 1,353,130
11 Unique poodles >10 lbs 788 dogs
12 Weight first sorted dog 50 lbs