Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am needing help with doing a couple of statements for SQL I have created these two tables: CREATE TABLE Stock ( Stock _ ID
I am needing help with doing a couple of statements for SQL
I have created these two tables:
CREATE TABLE Stock
StockID VARCHAR NOT NULL Primary Key,
Stockcategory VARCHAR
Stockshelf VARCHAR
Stockprice VARCHAR
Stockquantity INT
GO
CREATE TABLE Sales
TransactionID INT NOT NULL Primary Key,
CustomerID INT,
StockID VARCHAR
Saledate VARCHAR
Quantity INT
I need help with the following queries:
d Display all records from Sales, grouped by customer.
e Display the total sale value per customer, sorted by customer, for a given date of sales.
f Display sales value, categorywise, sorted by date.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started