Informatics Practices > Database Query using SQL > Sql Functions

Write suitable SQL queries for the following:

I. To display the average score from the

column in the Exams table.

II. To display the last three characters of the

column in the Vehicles table. (Note: Registration numbers are stored in the format )

III. To display the data from the

column in the Users table, after eliminating any leading and trailing spaces.

IV. To display the maximum value in the

column of the Employees table.

V. To determine the count of rows in the Suppliers table.