Use the stand alone SQl Interpreter located at http://sqlcourse2.com/sql_interpreter.html to perform the follow tasks. Copy each command word for word as you have used in the Interpreter as the answer to each task below. Each task is worth 10 points each

  1. Task:      Select all records from the table customers where the state is Arizona and      order the rows by city.
         Student Answer:
  2. Task:      Select all records from the table items_ordered where the item is a      bicycle or a helmet.
         Student Answer:
  3. Task:      Select the date, item, and price from the items_ordered table for all of      the rows that have a price value ranging from 10.00 to 80.00. Order by      price.
         Student Answer:
  4. Task:      Select item and price from the items_ordered table and round the price to      nearest whole integer.
         Student Answer:
  5. Task:      Select the firstname column from the customers table and have it displayed      in all lower case letters.
         Student Answer:
  6. Task:      Select the maximum price from the items_ordered table.
         Student Answer:
  7. Task:      Write a query with a join where you display customer firstname, lastname      and item(s) ordered by that customer. Order by customer last name.
         Student Answer:
  8. Task:      Determine the total number of rows in the customers table.
         Student Answer:
  9. Task:      Determine the total sum of all prices of items in the items_ordered table.
         Student Answer:
  10. Task:      How many orders did each customer make? Use the items_ordered table.      Select the customerid, number of orders they made, and the sum of their      orders if they purchased more than 1 item.
         Student Answer:



Source link

Leave a Reply

Your email address will not be published.