Assignment 3 -- Creating Simple and Advanced Queries
This assignment teaches you how to create simple queries -- you will be using MySQL Workbench from here on. DO NOT use MySQL command line
In your hobby database, you should have at least 3 tables you created in assignment 2. If you need more, feel free to make more.

For this assignment, I would like you to create 4 simple queries that access your hobby database and do the following:
  • Return everything in the table
  • Select 3 fields
  • Use a WHERE clause
  • Use Alias columns
  • Save your script
Run your script and take a screenshot of everything working with no errors
Hybrid Class Assignment -- Creating Simple and Advanced Queries Continued
This assignment teaches you how to create advanced queries
For this hybrid part, let's make it a little more challenging. Still using your hobby database, create the following:
  • A sub-query
  • A query using REGEXP
  • A query with at least 10 keywords
  • Save your script
Run your script and take a screenshot of it working with no errors
Assignment Submission Criteria
To turn in this assignment you will go to the NSC Canvas shell for this class and submit the following:
  1. Your .sql script file(s)
  2. Screenshots of your output


Return to Assignment Index