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 of