SQL Queries Activity

Description

You will be playing a game amoungst your teammates and instructor(s). The goal is to use the following concepts to create questions for your teammates. Take turns creating problems with solutions, quizzing one another, and verifying their answer with your own solution. At the end of the activity, have your group select your best question. The instructor will now be asked each groups question so try to stump them!

Concepts

  • Querying a table
  • Aliasing columns
  • Filtering
    • Comparisons
    • Range
    • Pattern Matching
  • NULL values

Setup

Open the attached file in MySQLWorkbench and execute

Submission

Create a pull request containing all the questions and answers