Single Table Query Assignment - Flower shop

  • Due Sep 20, 2021 by 11:59pm
  • Points 150
  • Submitting a file upload
  • File Types sql
  • Available Sep 13, 2021 at 12am - Sep 21, 2021 at 11:59pm
This assignment was locked Sep 21, 2021 at 11:59pm.

Write a SELECT Query for each of the Information Requests in the Vinyl Collection PDF Document.  Use the Metadata Table included in the PDF Document for assistance in determining the Datatypes and context of the attributes in the table

 

Use the SQL Text File below named CREATE Flower Shop Database.sql to create the Sample Database to Test your SELECT Queries.  

 

Link to the Metadata and the Assignment Information Requests

Flower MetaData with Requests Single Table-3.pdf Download Flower MetaData with Requests Single Table-3.pdf 

 

 

Link to the SQL Script to Create the Database, Table, and INSERT Test Data

Download FlowerShop SingleTable-2.sql

 

  

 

 

1632196799 09/20/2021 11:59pm