Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a ) List the FirstName, LastName, and Phone Number of customers who cancelled their Furniture Orders. Furniture is a category in the Products Table (

a) List the FirstName, LastName, and Phone Number of customers who cancelled their Furniture Orders. Furniture is a category in the Products Table (Save the Query as Q1).
b) Create a query that displays number of orders, total and average values of orders by Region Name. Value is a calculated field and is obtained by multiplying Price with Quantity (Save the Query as Q2).
I
c) Create a query that lists employee's first name, last name, salary, FICA, and Withholding. FICA and Withholding are calculated fields. FICA =6.75% of Salary and Withholdino =20% of Salary Name FICA and Withholdine-as FICA and Withholdine
image text in transcribed

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

Big Data Concepts, Theories, And Applications

Authors: Shui Yu, Song Guo

1st Edition

3319277634, 9783319277639

Students also viewed these Databases questions

Question

Describe the team performance model.

Answered: 1 week ago

Question

Write Hund's rule?

Answered: 1 week ago

Question

=+2 Is the decision sustainable in the long run?

Answered: 1 week ago