Need an MS SQL Server database schema and 2 queries
$15-20 USD
Dibayar saat pengiriman
Hello! This is a small project for a commercial enterprise. The deliverable is T-SQL code that generates database tables with sample data and two queries as a result for task "b". Database schema should be as effective as possible for future extension. Thanks!
## Deliverables
Here goes the tasks: Orders are described by the fields: "Order Number", "Order Date", "Sales Representative", "Customer". Each order may contain a variable number of lines that describe the contents of the order: "Product", "Price", "Quantity" (it is assumed that one order may have multiple lines with the same product). a) Create an appropriate SQL server database scheme. b) Create the following queries: - Get the specific product quantity of an average order for a specific Sales Representative. - For a specific Customer get the total cost of orders, in which the total price of a specific product is higher than a specified value.
ID Proyek: #2707916