Course Hero Logo

AssignmentWeek10.sql - #Week 10

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 2 pages.

#Week 10 assignmentSETsql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';#Query #1 1. Get the average quantity that we have in all our bike stocks.#Round to the nearest whole number.USE bike;SELECT ROUND(AVG(quantity)) AS 'Stock Average'FROM stock;#Query #2#Show each bike that needs to be reordered (those bikes that are out of stock).#(hint for this one: Two different stores have the same bike that needs to be
reordered, you only need it to show up once.)

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 2 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
DARINDAVIS
Tags

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture