Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ans all pls Queries a, b, c, d, e, and f require Computer Assignment 1 database file a) List the FirstName, LastName, and Phone Number
ans all pls
Queries a, b, c, d, e, and f require Computer Assignment 1 database file 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 (Save the Query as Q2). 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 Withholding = 20% of Salary. Name FICA and Withholding as FICA and Withholding (Save the Query as Q3). d) List the first name, and last name of customers where the third character in the last name is e (Save the Q4). e) Create a parameter query to list employees' first name, last name, salary, and date hired by Department. Department name to be entered at run time (Save the Query as Q5). f) List First Name, Last Name, and Salary of employees with a job rating ofStep 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