the lifestyle manager decides to give customers who bought three or more units of the same...
the lifestyle manager decides to give customers who bought three or more units of the same product in the same order a 20 percent discount. Show order id, product id, price, quantity and discounted price for those discounted in orderdetails
I have the sql working except I cannot figure out the discounted price
SELECT OrderID, ProductID, quantity, Price, Price *0.20 AS "Discounted Price" From Sales.OrderDetails where OrderID >1 and quantity >2
Example
OrderID ProductID Price Quantity Discounted Price
2 4 99.99 6 79.99200
In my statement about I am not getting 79.99200 the rest I have is correct. Help please
Homework Answers
You should use brackets and it should work as intended.
SELECT OrderID, ProductID, quantity, Price, (Price * 0.20) From Sales.OrderDetails where OrderID >1 and quantity >2
Add Answer to:
the lifestyle manager decides to give customers who bought three
or more units of the same...
Create the following SQL Server queries that access the Northwind database Same as problem 3 but,...
Create the following SQL Server queries that access the
Northwind database
Same as problem 3 but, limit the list to all customers who
placed 3 or more orders.
The product id, product name, last date that the product was
ordered for all items in the Grains/Cereals category. (Hint: Use
MAX)
The product ID, product name, and number of distinct customers
who ordered that product in 1996
Thank you.
Categories Customers Employees Order Details Orders Products Shippers 9 CategoryID CategoryName Description...
A database used for a toy store that keeps track of the inventory and purchase orders...
A database used for a toy store that keeps track of the inventory and purchase orders from the store. All clients will have their membership ID card to shop. This database will help the store to keep track of their orders. It will also help the store to know how many products are available in the inventory. It is necessary to have a membership to purchase a product. The customer can also bring coupons to get discount. Key attributes: Salesman:...
A database used for a toy store that keeps track of the inventory and purchase orders...
A database used for a toy store that keeps track of the inventory and purchase orders from the store. All clients will have their membership ID card to shop. This database will help the store to keep track of their orders. It will also help the store to know how many products are available in the inventory. It is necessary to have a membership to purchase a product. The customer can also bring coupons to get discount. Key attributes: Salesman:...
List the names of all customers who bought both envelopes and labels (either in the same order or different orders).please give me an sql query for this question and i have tables as follows customer(...
List the names of all customers who bought both envelopes and labels (either in the same order or different orders).please give me an sql query for this question and i have tables as follows customer(customer_name,address,zipcode,customer_id,state),office_supplies(item_name,item_id,cost,category),orders(order_id,date,customer_id) order_details(quantity,order_id,item_id)
can someone solve these quick please and thank you! sql chapter 4 Query #1: List the...
can someone solve these quick
please and thank you!
sql chapter 4
Query #1: List the company name, contact name, contact title and
the phone number for customers who HAVE NOT put in an order. Use an
outer join.
Query #2: Create a listing displaying the employee first name,
last name and the full name (First name space Last Name) of the
person they report to (Supervisor). This is a self-join. If an
employee does not report to anyone then...
If possible please just send the SQL statement. Thank you Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top o...
If possible please just send the SQL statement. Thank you
Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top of each page. Also, using a 12-point font, include the SQL statement and then provide a screen shot of each query. The screen shots must include both the SQL statement and the results for each item below based on the data entered in...
The Northwind database created by Microsoft contains the sales data for a fictitious company called Northwind...
The Northwind database created by Microsoft contains the sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world. Here is the schema of the database: Products (ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued); Suppliers (SupplierID, CompanyName, ContactName , ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, HomePage); Categories (CategoryID, CategoryName, Description, Picture); Orders (OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName,ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry); Order_details (ID, OrderID,...
Hello, I need help answering all 8 of these questions for my BIS 422 class. I...
Hello, I need help answering all 8 of these questions for my BIS
422 class. I need the appropriate MySQL script to use for these
questions
Provide the SQL for the following data requests. Your SQL should
be written as a single script that can be pasted into MySQL and run
without edits. Make sure you use the proper notation for your
comments (see the practice solution for an example of the format).
There will be a 5% deduction for...
Questions are based on the Northwind database. a. A data dictionary (Excel file) that describes each...
Questions are based on the Northwind database.
a. A data dictionary (Excel file) that describes each of the
tables. (Attached in question)
b. Write good, clean SQL that answers the
following questions.
c. Separate your queries as I have
done in the following example. End each query with a semicolon (;)
and insert the word "go" between each query. Queries can span
multiple lines if required.
Select CustomerID from Customers;
go
Select Count(*) from Employees;
go
Select max(productID) from Products;
18. Produce...
There was no question about Carl’s genius. Seven years ago he decided to enter the competitive...
There was no question about Carl’s genius. Seven years ago he decided to enter the competitive nightmare that the personal computer business had become. Although on the surface that appeared to be a rather non-genius-like move, the genius came in the unique designs and features that he developed for his computer. He also figured a way to promise delivery in only two days for the local and regional market. Other computer makers also had rapid production and delivery, but they...
Create the following SQL Server queries that access the
Northwind database
Same as problem 3 but, limit the list to all customers who
placed 3 or more orders.
The product id, product name, last date that the product was
ordered for all items in the Grains/Cereals category. (Hint: Use
MAX)
The product ID, product name, and number of distinct customers
who ordered that product in 1996
Thank you.
Categories Customers Employees Order Details Orders Products Shippers 9 CategoryID CategoryName Description...
can someone solve these quick
please and thank you!
sql chapter 4
Query #1: List the company name, contact name, contact title and
the phone number for customers who HAVE NOT put in an order. Use an
outer join.
Query #2: Create a listing displaying the employee first name,
last name and the full name (First name space Last Name) of the
person they report to (Supervisor). This is a self-join. If an
employee does not report to anyone then...
If possible please just send the SQL statement. Thank you
Each question within deliverable 3 must begin on a new page and be sure to document the question as the title of each item at the top of each page. Also, using a 12-point font, include the SQL statement and then provide a screen shot of each query. The screen shots must include both the SQL statement and the results for each item below based on the data entered in...
Hello, I need help answering all 8 of these questions for my BIS
422 class. I need the appropriate MySQL script to use for these
questions
Provide the SQL for the following data requests. Your SQL should
be written as a single script that can be pasted into MySQL and run
without edits. Make sure you use the proper notation for your
comments (see the practice solution for an example of the format).
There will be a 5% deduction for...
Questions are based on the Northwind database.
a. A data dictionary (Excel file) that describes each of the
tables. (Attached in question)
b. Write good, clean SQL that answers the
following questions.
c. Separate your queries as I have
done in the following example. End each query with a semicolon (;)
and insert the word "go" between each query. Queries can span
multiple lines if required.
Select CustomerID from Customers;
go
Select Count(*) from Employees;
go
Select max(productID) from Products;
18. Produce...
Most questions answered within 3 hours.
-
In C++
In this homework, you will be tasked with creating functions to
manipulate strings that...
asked 15 minutes ago -
An isolated colony represents a pure culture. one rare occasions
, however , a colony can...
asked 29 minutes ago -
*****DO NOT ANSWER THIS QUESTION IF YOU DON'T
KNOW*******Rights and Duties of Auditors; Minimum 4000
words...
asked 1 hour ago -
The probability that Janie is wearing sunglasses is 1/4. The
probability that she is wearing sunglasses...
asked 1 hour ago -
Do you believe social media is more of a help or a hindrance in
controlling crises...
asked 2 hours ago -
Two long, parallel wires separated by 2.85 cm carry currents in
opposite directions. The current in...
asked 1 hour ago -
Question # 1. Develop a list of rehabilitation journals
that publish articles concerning career counseling for...
asked 2 hours ago -
Bryant Company has a factory machine with a book value of
$85,100 and a remaining useful...
asked 2 hours ago -
What is the default classification for federal tax purposes of a
U.S. eligible entity with one...
asked 2 hours ago -
1. How many grams would 4.0x1021 atoms of calcium
weigh?
2.. Calculate the percent oxygen in...
asked 2 hours ago -
Balance Equation
K2Cr2O7 + H2C2O4 2H2O 6 K[Cr(C2O4 )2 (H2O)2 ]2H2O + CO2 +
H2O
asked 2 hours ago -
Select a position in the clinical laboratory and write an
appropriate job description and corresponding work...
asked 2 hours ago