I would like to increase sales at our car dealership. What we need is to have a clear picture of which cars are currently selling best. The first step is to set up a database from which we can pull reports.
The full spec is included in the repo in the file called business scenario.sql.
The 3 files listed below are required to implement the requirements for this repo. The info for each one is in the spec.
- table.sql (create database and table)
- sample data.sql
- reports.sql
- primary key
- properly named columns
- proper data types
- not null as apporpriate
- constraints
- files should be able to run repeatedly so include drop and use statements