Make a list of customers with the list of orders and the amount of dollars that they paid for each of their orders.   Make a list of customers with the total amount of dollars that they paid for all their orders combined (for each customer).

List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.

Use select statements to create queries that answer the following questions. Only provide the information requested.  Do not provide the output.  All tables are provided below List the name of all bouquets that are priced at $29.99. List the customer id for all customers who ordered item 7.

StayWell’s maintenance team wants to recheck the apartments that had plumbing service requests beforehand. You will need to return all the property IDs and the addresses of the properties that had plumbing service request (CATEGORY_NUMBER 1). Task   Return a list of all the property IDs and the addresses of the properties that had plumbing service requests.

Query 3: Write a parameter query to display the names of all prospects each member tried to recruit based on the member’s first name and the member’s last name you input. List the member’s First Name, member’s Last Name, prospect’s First Name, and prospect’s Last Name (in this order in the query grid). Display the member’s First Name Heading as Member First Name, member’s Last Name Heading as Member Last Name, prospect’s first name heading as Prospect First Name, and prospect’s last name heading as Prospect Last Name. Sort the list by Member Last Name, Member First Name, Prospect Last Name, and Prospect First Name, all ascending order.   (WE ARE USING ACCESS SO I AM JUST TRYING TO UNDERSTAND WHAT TO PUT AND PLUG IN ETC. USE MY PICTURES AS REFERRENCE!)

Which of the following statements is valid? (refer to the tables in the JustLee Books database.)a. SELECT title FROM booksWHERE retail<(SELECT cost FROM booksWHERE isbn = '9959789321');b. SELECT title FROM booksWHERE retail = (SELECT cost FROM booksWHERE isbn = '9959789321' ORDER BY cost);c. SELECT title FROM booksWHERE category IN (SELECT cost FROM orderitemsWHERE isbn = '9959789321');d. none of the above statements

3. Run a query that gives the average grade on the final exam for male students and for femalestudents. Round that number to 1 decimal place only.

Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.

What is the main difference between the set operators and the join?

The PatientDim table contains columns. PatientEpicId and name. Use the following query to answer the questions below it: SELECT PatientEpicID Name FROM PatientDim What does this query return?   select one of the following: A. Nothing because the query won't run.B. The column PatientEpicId and name from the table PatientDimC. The PatientEpicID column  from the table PatientDim, with an alias of name.D. The name column from the table PatientDim, with an alias of PatientEpicId