/* select * from JUDGE;
select * from SCHOOL;
select * from JUDGE_COMPETITION;
select * from COMPETITION;
select * from COMPETITION_COMPETITOR;
select * from COMPETITOR;
select * from BRIEF;
select * from TEAM;
select avg (Final_Brief_Score) from BRIEF whereFinal_Brief_Score > 0
select max (Final_Brief_Score) from BRIEF whereFinal_Brief_Score > 0
select min (Final_Brief_Score) from BRIEF whereFinal_Brief_Score > 0
select School_Name, SJU_Assigned_Team_Number from SCHOOL,TEAM
WHERE School.School_ID = TEAM.School_ID
order by SCHOOL.School_ID
select Judge_ID, Judge_First_Name, Judge_Last_Name, Judge_Statefrom JUDGE where Judge_State not in (‘NY’)
select JUDGE.Judge_ID, Judge_Last_Name ,COMPETITION.Competition_Number , ROUND , Competition_Date,Competition_Time
from JUDGE, JUDGE_COMPETITION, COMPETITION
where JUDGE.Judge_ID = JUDGE_COMPETITION.Judge_ID
and COMPETITION.Competition_Number =JUDGE_COMPETITION.Competition_Number
select COMPETITOR.Competitor_ID, Competitor_First_Name ,Competitor_Last_Name, Score_One
from COMPETITION_COMPETITOR, COMPETITOR
where COMPETITOR.Competitor_ID =COMPETITION_COMPETITOR.Competitor_ID
and Score_One > 0
ORDER BY Competitor_Last_Name
*/
Create view Competitor_Overview as
select Competitor_ID Competitor_Last_Name ,Competitor_First_Name
from COMPETITOR
go
select * from Competitor_Overview
select COUNT (round)
from COMPETITION
where ROUND * Octo I;
1.Count how many competitions thereare in the Octo I round. Submit the query and the answer. (SQL)
Expert Answer
Answer to /* select * from JUDGE; select * from SCHOOL; select * from JUDGE_COMPETITION; select * from COMPETITION; select * from …