SQL HW2

1
SQL HW2

• Turn in as a hardcopy at the start of next class
  period. You may work this assignment in groups.

2
Using MySQL

• The MySQL server is on candler.cs.unca.edu
• ssh to candler before connecting to the MySQL
  server
• Logon to the server using the student account as
  follows
• candlergt mysql u student
• This account does not have a password
• Use the orderEntry database for this HW
• mysqlgt use orderEntry
• To run a query that has been stored in a file
  with the name query1.sql (in the current working
  directory)
• mysqlgt source query1.sql

3
Formulate the following queries in SQL and turn
in a hardcopy of each query

• Develop queries to answer the following questions
  from page 125 126 of your textbook
• 18, 20, 27, 30