I want a perfect answer to the question. I wrote down the question and wrote down the wrong code at the bottom, but I want another code, not the same as this one, and please use the name written next to the create table. Q1 is question This is the best screen shot.

Question

Q1. Find the course(s) taken by the fewest students in the year 2006. The result should display the course title and the number of students. If a student has taken the same course more than once, this student should be counted only once.

this one is the wrong code can you give me another one do not give me the same code I want the different code

Wrong code

with courses_enrollment as

(

select course_id, count(distinct takes.ID) as number_students

from takes

where year = '2006'

group by course_id

)

select c.title, ce.number_students

from course as c join courses_enrollment as ce

on c.course_id = ce.course_id

order by number_students

limit 1;

nofnam vau (T) Masiagas Connenjs concleted spocesstu11?. Do Quick Launch (Ctrl I Q) = File Edit View Query Project Tools Window Help Maskiagas Conmends concleted soctessevil? Masisings Connands concleted soctesstu11:. Query executed successfully. Quick Launch (Ctrl I Q) = File Edit View Query Project Tools Window Help