Web Reference: SELECT name, no_of_views FROM video GROUP BY name, no_of_views ORDER BY no_of_views DESC, name ASC LIMIT 10; 2. SELECT video.name AS video_name, no_of_views, channel.name AS channel_name FROM video INNER JOIN channel ON video.channel_id = channel.channel_id ORDER BY no_of_views DESC, channel.name ASC LIMIT 10; 3. Create PROC enrollInCourse @sid INT, @cid INT, @instr int AS BEGIN if (exists (select * from CoursePrerequisiteCourse where cid=@cid)) begin if (exists (select * from StudentTakeCourse where sid=@sid and cid in (select preid from CoursePrerequisiteCourse where cid=@cid))) INSERT INTO StudentTakeCourse (sid,cid,insid) VALUES (@sid,@cid,@instr) else print 'Student didnt take this course pre-requisite' end else INSERT INTO StudentTakeCourse (sid,cid,insid) VALUES (@sid,@cid,@instr) END go CREATE PROC addCreditCard @sid int, @number varchar (15), @cardHolderName varchar (16), @expiryDate datetime, @cvv varchar (3) AS IF (EXISTS (SELECT * FROM Users WHERE id=@sid)) BEGIN INSERT INTO CreditCard VALUES (@number,@cardholderName,@expiryDate,@cvv) insert into StudentAddCreditCard values (@sid,@number) END go CREATE PROC viewPromocode @sid int AS SELECT P.* FROM Promocode P inner join StudentHasPromocode SP on SP.code = P.code where SP.sid=@sid go CREATE PROC enrollInCourseViewContent @id int, @cid int AS BEGIN IF (EXISTS (SELECT * FROM Users WHERE id=@id)) SELECT C.* FROM Course C INNER JOIN StudentTakeCourse STC ON C.id = STC.cid INNER JOIN Student S ON STC.sid = S.id INNER JOIN Users Us ON Us.id = S.id WHERE Us.id = @id and c.id=@cid ELSE print 'not a user' END go CREATE PROC viewAssign @courseId int, @Sid VARCHAR (10) AS BEGIN IF (EXISTS (SELECT * FROM Users WHERE id=@Sid)) SELECT DISTINCT A.* FROM Assignment A INNER JOIN Course C ON A.cid = C.id WHERE C.id = @courseId ELSE print 'not a user' END go CREATE PROC submitAssign @assignType VARCHAR (10), @assignnumber int, @sid INT, @cid INT AS BEGIN IF (EXISTS (SELECT * FROM StudentTakeCourse WHERE cid = @cid AND sid = @sid )) BEGIN IF (EXISTS (SELECT * FROM StudentTakeAssignment WHERE assignmenttype = @assignType AND assignmentNumber = @assignnumber)) print 'Already submitted' ELSE INSERT INTO StudentTakeAssignment values (@sid,@cid,@assignnumber,@assignType,null) END ELSE print 'not enrolled in course' END GO --View the grades of each assignment type. Contribute to adityashakya07/SQL-Join-and-Foreign-key- development by creating an account on GitHub.
YouTube Excerpt: SQL Milestone 1|| Assignment 2|| 💯Correct Answers||CCBP 4.0|| NXTWAVE
Information Profile Overview
Assignment 2 Sql Nxtwave Sql - Latest Information & Updates 2026 Information & Biography
Details: $28M - $40M
Salary & Income Sources
Career Highlights & Achievements
Assets, Properties & Investments
This section covers known assets, real estate holdings, luxury vehicles, and investment portfolios. Data is compiled from public records, financial disclosures, and verified media reports.
Last Updated: April 4, 2026
Information Outlook & Future Earnings
Disclaimer: Disclaimer: Information provided here is based on publicly available data, media reports, and online sources. Actual details may vary.