Consider the following tables CourseInfo CourseID Title…
Consider the following tables CourseInfo CourseID Title DS624 Database DS625 Statistics DS627 Security SectionInfo SectionID CourseID Semester Year 1 DS624 Fall 2020 2 DS624 Summer 2020 3 DS625 Fall 2020 SELECT CourseID, Count(SectionID) as SecCount FROM CourseInfo c INNER JOIN StudentInfo s ON c.CourseID = s.CourseID GROUP BY CourseID HAVING Count(SectionID) > 1; Write dbplyr code necessary to retrieve the same information as the query shown above. You may assume that you already have a connection to the database set up and you’ve run the following line of code: course
Read Details