CW4 Wed4pm_Group 1.docx - Q1 How many classes are held in room 3346 1 Translation Select count of all Class IDs From table Classes where ClassRoomID is

CW4 Wed4pm_Group 1.docx - Q1 How many classes are held in...

This preview shows page 1 - 3 out of 5 pages.

Q1 How many classes are held in room 3346? 3.Code as below:use schoolschedulingexample;SELECT COUNT(ClassID) AS 'Total No. of Classes'FROMclassesWHEREClassRoomID = 3346;Q2 Calculate the current average raw score and handicap for each bowler. 1. Translation – Select BowlerID, Average of Raw Scores and HandiCapScore From Table bowler_scores 2. Clean Up – SELECT BowlerID, avg(RawScore), avg(HandiCapScore) FROM bowler_scores GROUP BY BowlerID 3. Code as below SELECT BowlerID,
AVG(RawScore) AS 'Mean Raw Score', AVG(HandiCapScore) AS 'Mean HandiCap Score' FROM bowlingleagueexample.bowler_scores GROUP BY BowlerID; Q3. List all meat ingredients and the count of recipes that include each one.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture