Question: please provide the correct SQL information for ACCESS formatting I have SQL ACCESS, I just need to correct format lettering and/or number for the answer

please provide the correct SQL information for ACCESS formatting  please provide the correct SQL information for ACCESS formatting I have
SQL ACCESS, I just need to correct format lettering and/or number for
the answer than 1,000 . List in ordec from bighest ta lonvent
tuition SLLECT SUM(cousses/ As I Number of Courser) FROM enrolls WAVING sum
{ course } ? oltofo by courses 0EsC. Expected column names: stiadentKey,
I have SQL ACCESS, I just need to correct format lettering and/or number for the answer

than 1,000 . List in ordec from bighest ta lonvent tuition SLLECT SUM(cousses/ As I Number of Courser) FROM enrolls WAVING sum { course } ? oltofo by courses 0EsC. Expected column names: stiadentKey, AS Number of Courses For fulecence, here is a litt of atl tables and atthbutes. Cowrses: eoursekey, coursefiame, departnient, ctodits Entolfs enrollkey, sectionikey, SE(ECT COUNTfectionkey) AS WVumber at students], AVG(Brade) AS [Ayerage Grade] Expected colame names. fROMientols Whitie norgectiogky? 3 rectionkey, AS Number of Studentri ORDER EY AVGEadel ofse; AS Averake Grade For referdnce, here is a lit of all tableskand atuibuters: Courses cqursekiy, courseName. Gepartment, credits List the numbur of students in each sectoo and the average gradefor each section for which the averoge gaile is 3 or highier. Or der by meraer soabe descundire Expected colanin names: studeakiey, As Averpetinde Ch Numben of Courses formeterence, hece n a list of all tobins and atirituae Coutses: coursekry, courla Nume, deasriment, rinidits then by mudentkey ascendinef SELECI AvG(arade) AS (Average Gradel, COUNTKstudentkey) AS (Number of Students). Fepected column names: ffoMenralls sectionkey, fsw Merage 6 iade, As GROUP BY iYade ANO shidenther >2 OHbER HYstudentker: Number ok Students For teference, here is a ist of ail rables and atiributes: Courses: coutsekev, courseName. department, crediti: Lis the iverage grade and number of students for each section with more than 2 students. Sort from least to most students

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!