Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

write SQL queries for this table given below Show the stock value (holding cost) for each product. (Price transaction with stock quantity) If I had

write SQL queries for this table given belowimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedShow the stock value (holding cost) for each product. (Price transaction with stock quantity)

If I had increased each salesperson's quota by 3 percent of their annual sales, their new quota would be

List offices with sales below 80 percent of target?

List salespeople who have exceeded their quota?

List salespeople whose sales are not between 80 percent and 120 percent of their quota?

List salespeople who work in New York, Atlanta, or Denver?

List all orders placed on Fridays in January 2008?

The product code consists of 5 characters, the code starts with any number, the second character is "A" whose third and fourth characters are any number, whose character is any letter list the products?

Find the salesperson who has not yet been assigned to an office?

Sort offices in descending order of sales so that the offices with the largest sales appear first?

Rank the offices in descending order of sales performance so that the offices with the best performance (by percentage of target realization) appear first?

All products with the price of the product exceeding $2,000 and more than $30000 in a single order List in descending order by order amount?

25,000, including the name of the salesperson who took the order and the name of the customer who placed the order List orders over $?

The name of the customer who placed the order, the salesperson of the customer and the office where the salesperson works List orders over $25,000 showing?

Find all orders received on the day a new salesperson was hired?

Regardless of which office the salesperson works in, the salesperson's quota all salesperson and office combinations where any one office outstrips its target list?

What is the first order date in the database? (Only this date should be listed)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Demystifying Databases A Hands On Guide For Database Management

Authors: Shiva Sukula

1st Edition

8170005345, 978-8170005346

More Books

Students also viewed these Databases questions

Question

3. Define the attributions we use to explain behavior

Answered: 1 week ago