Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
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