course_sql

Problem: What is Morgantown’s weather?

We will use concepts from SQL2 to investigate Morgantown’s weather patterns.

Outcome

• Practice SELECT, FROM, WHERE, ORDER BY, AS, and other concepts introduced in SQL2.

Process

• Download the db file
• Download the sql file
• Move both files into a new folder.
• Open DB Browser and choose File / Open DB
• Go to the execute SQL tab. Then, use the 2nd button from the left to open the SQL file
• Start answering questions!