This is my pageant_contestant table now i wanted to group the judge no by judgeno

 

 

Now this is my first query and it works ....what i wanted to get is the number of rows which will be equals to 2. Can you help me with the subquery?

 

Transcribed Image Text:

SQLQuery8.sql - DESKTOP-9DIR907\SQLEXPRESS01.system1 (DESKTOP-9DIR907\Chrissha Mae (71)) - Microsoft SQL Server Management Studio File Edit View Query Project Tools Window Help New Query MMMM system1 Object Explorer Connect = + endTermReq finalexam + hris2 + KCC + midterm pageant W =system1 Database Diagrams Tables System Tables FileTables External Tables Graph Tables dbo.category dbo.contestant dbo.criteria < Quick Launch (Ctrl+Q) class_code.subject = Execute 2 == SQLQuery8.sql - DE...\Chrissha Mae (71)) XSQLQuery7.sql - DE...\Chrissha Mae (53))* /****** Script for Select TopNRows command from SSMS ******/ SQLQuery6.sql - DE...\Chrissha Mae (59)) SQLQuery5.sql - DE...\Chrissha Mae (52)) SELECT TOP (1000) [ID] , [contestantno] , [judgeno] , [scoreID] FROM [system1].[dbo].[pageant_contestant] dbo.judge dbo.organizer 100% Results Messages dbo.pageant ID contestantno judgeno scorelD dbo.pageant_contestant 1 1 1 1 +dbo.score 2 2 1 1 2 Views 3 3 1 1 3 External Resources 4 4 1 1 4 Synonyms 5 5 1 1 5 Programmability 6 6 4 1 6 Service Broker 7 7 4 1 7 Storage 8 8 1 4 8 Security 9 9 1 4 9 TestLanggg 10 10 2 4 10 Security Server Objects Replication PolyBase Management XEvent Profiler Ready Type here to search Query executed successfully. C DESKTOP-9DIR907\SQLEXPRESSO... DESKTOP-9DIR907\Chriss... system1 00:00:00 10 rows Ln 6 Col 40 Ch 40 INS W ) ENG 3:55 pm 28/08/2022 SQLQuery8.sql - DESKTOP-9DIR907\SQLEXPRESS01.system1 (DESKTOP-9DIR907\Chrissha Mae (71)) - Microsoft SQL Server Management Studio File Edit View Query Project Tools Window Help New Query MMMM system1 Object Explorer Connect = + endTermReq finalexam + hris2 + KCC + midterm pageant W =system1 Database Diagrams Tables System Tables FileTables External Tables Graph Tables dbo.category dbo.contestant dbo.criteria < Quick Launch (Ctrl+Q) class_code.subject = Execute 2 == SQLQuery8.sql - DE...\Chrissha Mae (71)) XSQLQuery7.sql - DE...\Chrissha Mae (53))* /****** Script for Select TopNRows command from SSMS ******/ SQLQuery6.sql - DE...\Chrissha Mae (59)) SQLQuery5.sql - DE...\Chrissha Mae (52)) SELECT TOP (1000) [ID] , [contestantno] , [judgeno] , [scoreID] FROM [system1].[dbo].[pageant_contestant] dbo.judge dbo.organizer 100% Results Messages dbo.pageant ID contestantno judgeno scorelD dbo.pageant_contestant 1 1 1 1 +dbo.score 2 2 1 1 2 Views 3 3 1 1 3 External Resources 4 4 1 1 4 Synonyms 5 5 1 1 5 Programmability 6 6 4 1 6 Service Broker 7 7 4 1 7 Storage 8 8 1 4 8 Security 9 9 1 4 9 TestLanggg 10 10 2 4 10 Security Server Objects Replication PolyBase Management XEvent Profiler Ready Type here to search Query executed successfully. C DESKTOP-9DIR907\SQLEXPRESSO... DESKTOP-9DIR907\Chriss... system1 00:00:00 10 rows Ln 6 Col 40 Ch 40 INS W ) ENG 3:55 pm 28/08/2022