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 MySQLThe MySQL server is on candler.cs.unca.edussh to candler before connecting to the MySQL serverLogon to the server using the student account as follows:candler> mysql –u studentThis account does not have a passwordUse 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