Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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 image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions