Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the average discount offered for different types of credit cards? Hint: Find out the average of discount for each credit card type.*/ i

What is the average discount offered for different types of credit cards?

Hint: Find out the average of discount for each credit card type.*/

i need proper sql query for this statement

image text in transcribed
New wheels Data Dictionary shipper_id: Unique ID of the Shipper shipper_name: Name of the shipper shipper_contact_detai1s: Contact detai1 of the shipper product_id: Unique ID of the Product vehicle_maker: vehicle Manufacturing company name vehicle_mode 1: Vehicle model name vehicle_color: color of the vehicle vehicle_mode1_year: Year of Manufacturing vehicle_price: Price of the vehicle quantity: ordered Quantity customer_id: Unique ID of the customer customer_name: Name of the customer gender: Gender of the customer job_title: Job Title of the customer phone_number: Contact detai1 of the customer emai1_address: Email address of the customer city: Residing city of the customer country: Residing country of the customer state: Residing state of the customer customer_address: Address of the customer order_date: Date on which customer ordered the vehicle order_id: Unique ID of the order ship_date: Shipment Date ship-mode: Shipping Mode/class shipping: shipping ways posta1_code: Postan code of the customer discount: Discount given to the customer for the particular order by credit card in percentage credit_card_type: credit Card Type credit card number: Credit card number customer_feedback: Feedback of the customer quarter_number : Quarter Number

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

More Books

Students also viewed these Databases questions

Question

1. Discuss the four components of language.

Answered: 1 week ago

Question

f. What stereotypes were reinforced in the commercials?

Answered: 1 week ago