Functions Display total number of trips (to Chicago) Count Returns the number of records that would have appeared in the query results instead of the records Display total amount of themselves expenses (format) (to Select Count(*) From STUDENT Chicago) Where Major=’CIS’ If implementation of SQL the *, use doesn’t support Display min and max the primary key field name instead duration Sum Returns the sum of a field of all the records that would have appeared instead of the records themselves Display average cost per Select Sum(Credits) From ENROLL day Where LName=’Gaul’ Avg Returns the average of a field from all the records. Min Returns the smallest value of a field from all the records. Max Returns the largest value of a field from all the records.
Functions Count Returns the number of records that would have appeared in the query results instead of the records themselves Select Count(*) From STUDENT Where Major=’CIS’ If implementation of SQL doesn’t support the *, use the primary key field name instead Sum Returns the sum of a field of all the records that would have appeared instead of the records themselves Select Sum(Credits) From ENROLL Where LName=’Gaul’ Avg Returns the average of a field from all the records. Min Returns the smallest value of a field from all the records. Max Returns the largest value of a field from all the records. Display total number of trips (to Chicago) Display total amount of expenses (format) (to Chicago) Display min and max duration Display average cost per day
3%20-%20Single%20Table%20Queries.docx