Unformatted text preview:

SQL HW2Using MySQLFormulate the following queries in SQL and turn in a hardcopy of each query:SQL HW2Turn in as a hardcopy at the start of next class period. You may work this assignment in groups.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:candler> mysql –u studentThis account does not have a passwordUse the orderEntry database for this HW: mysql> use orderEntry;To run a query that has been stored in a file with the name query1.sql (in the current working directory):mysql> source query1.sql;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,


View Full Document

UNCA CSCI 343 - SQL Homework

Download SQL Homework
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view SQL Homework and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view SQL Homework 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?