100%(6)6 out of 6 people found this document helpful
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_scores2.Clean Up– SELECT BowlerID, avg(RawScore), avg(HandiCapScore) FROM bowler_scores GROUP BY BowlerID3.Code as belowSELECT BowlerID,
AVG(RawScore) AS 'Mean Raw Score',AVG(HandiCapScore) AS 'Mean HandiCap Score'FROMbowlingleagueexample.bowler_scoresGROUP BY BowlerID;Q3. List all meat ingredients and the count of recipes that include each one.