this question is already on Chegg but does not have an answer. I need help with

Question

this question is already on Chegg but does not have an answer. I need help with 5 and 6

Download the database and open it in MS Access. Look at the Piano table,b familiar with the fields, and think of questions you might be able to answer Now create queries to provide the following information. For each one, clip t rows of the result, and include the clip in a Word document BA370 Queries (Your Name, docx Submit your Word document in Canvas before the assignment deadline. 1. Sort the pianos from high quality to low 2. Sort the pianos from high quality to low and, within each quality, sort by and then by Location within that building. 3. List all of the pianos with a Type of Spinet. 4. List the pianos in the shed and sort the results by manufacturer. Count the pianos for each value of quality (ranging from I to 5) 6. Write a query to produce the report on the Last Slide in the class notes. AD

Explanation / Answer

Question 5.

SELECT <SoundQuality>,COUNT(*) FROM <table_name> GROUP BY <SoundQuality>

replace <table_name> with the table name for piano

replace <SoundQuality> with the column name for SoundQuality

Question 6.

SELECT <Building>,<SoundQuality>,COUNT(*) AS NumberPianos FROM <table_name> GROUP BY <Building>,<SoundQuality>

replace <table_name> with the table name for piano

replace <Building> with the column name for Building

replace <SoundQuality> with the column name for SoundQuality

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.