Advertisements
Advertisements
Question
Which one of the following is not an aggregate function?
Options
ROUND()
SUM()
COUNT()
AVG()
Advertisements
Solution
ROUND()
APPEARS IN
RELATED QUESTIONS
Which method is used to get the row-id of the last modified row?
The MAX () function finds the
Consider the table STUDENT given below:
| RollNo | Name | Class | DOB | Gender | City | Marks |
| 1 | Anand | XI | 6/6/97 | M | Agra | 430 |
| 2 | Chetan | XII | 7/5/94 | M | Mumbai | 460 |
| 3 | Geet | XI | 6/5/97 | F | Agra | 470 |
| 4 | Preeti | XII | 8/8/95 | F | Mumbai | 492 |
| 5 | Saniyal | XII | 8/10/95 | M | Delhi | 360 |
| 6 | Maakhiy | XI | 12/12/94 | F | Dubai | 256 |
| 7 | Neha | X | 8/12/95 | F | Moscow | 324 |
| 8 | Nishant | X | 12/6/95 | M | Moscow | 429 |
State the command to display the average marks scored by students of each gender who are in class XI?
(i) Select Gender, avg(Marks) from STUDENT where Class= "XI" group by Gender;
(ii) Select Gender, avg(Marks) from STUDENT group by Gender where Class="XI";
(iii) Select Gender, avg(Marks) group by Gender from STUDENT having Class="XI";
(iv) Select Gender, avg(Marks) from STUDENT group by Gender having Class = "XI";
Choose the correct option:
What will be the output of the following SQL statement?
SELECT DAY NAME (2022-04-08)
Assertion (A): COUNf function ignores DISTINCT
Reason (R): DISTINCT ignores the duplicate values.
Which of the following is not an aggregate function?
Which command is used to delete a table? (in SQL)
What will be returned by the given query? Select round(23456.1234, -2) = ______.
What will be returned by the given query? select mid("Computer", 2, 4) = ______.
What will be returned by the given query? select power(3, 2) = ______.
What will be returned by the given query? SELECT MID('LeaminglsFun', 2, 4) = ______.
Name a function of MySQL which is used to remove trailing and leading spaces from a string.
What will be returned by the given query? SELECT MID('BoardExamination', 2, 4) = ______.
Which of the following is not a date function?
Write the output produced by the following SQL statement:
SELECT YEAR(“1979/11/26”),
MONTH(“1979/11/26”), DAY(“1979/11/26”), MONTHNAME(“1979/11/26”);
Which function is used to display the total number of records from a table in a database?
Differentiate between count() and count(*) functions in SQL with appropriate examples.
Write the outputs of the SQL queries based on the relations Teacher and Placement given below:
Table: Teacher
| T_ID | Name | Age | Department | Date_of_join | Salary | Gender |
| 1 | Arunan | 34 | Computer Sc | 2019-01-10 | 12000 | M |
| 2 | Saman | 31 | History | 2017-03-24 | 20000 | F |
| 3 | Randeep | 32 | Mathematics | 2020-12-12 | 30000 | M |
| 4 | Samira | 35 | History | 2018-07-01 | 40000 | F |
| 5 | Raman | 42 | Mathematics | 2021-09-05 | 25000 | M |
| 6 | Shyam | 50 | History | 2019-06-27 | 30000 | M |
| 7 | Shiv | 44 | Computer Sc | 2019-02-25 | 21000 | M |
| 8 | Shalakha | 33 | Mathematics | 2018-07-31 | 20000 | F |
Table: Placement
| P_ID | Department | Place |
| 1 | History | Ahmedabad |
| 2 | Mathematics | Jaipur |
| 3 | Computer Sc | Nagpur |
- SELECT Department, avg(salary) FROM Teacher GROUP BY Department;
- SELECT MAX(Date_of_Join), MIN(Date_of_Join) FROM Teacher;
- SELECT Name, Salary, T.Department, Place FROM Teacher T, Placement P WHERE T.Department = P.Department AND Salary>20000;
- SELECT Name, Place FROM Teacher T, Placement P WHERE Gender = ’F’ AND T.Department = P.Department;
Which one of the following functions are used to find the largest value from the given data in MySQL?
Based on the table STUDENT given here, write suitable SQL queries for the following:
| Roll No | Name | Class | Gender | City | Marks |
| 1 | Abhishek | XI | M | Agra | 430 |
| 2 | Prateek | XII | M | Mumbai | 440 |
| 3 | Sneha | XI | F | Agra | 470 |
| 4 | Nancy | XII | F | Mumbai | 492 |
| 5 | Himanshu | XII | M | Delhi | 360 |
| 6 | Anchal | XI | F | Dubai | 256 |
| 7 | Mehar | X | F | Moscow | 324 |
| 8 | Nishant | X | M | Moscow | 429 |
- Display gender-wise highest marks.
- Display city-wise lowest marks.
- Display the total number of male and female students.
Write suitable SQL query for the following:
Display the position of occurrence of the string ‘COME’ in the string ‘WELCOME WORLD’.
Write suitable SQL query for the following:
Display the remainder of 100 divided by 9.
Write suitable SQL query for the following:
Remove all the expected leading and trailing spaces from a column userid of the table ‘USERS’.
Explain the following SQL function using a suitable example.
MID()
Explain the following SQL function using a suitable example.
DAYNAME()
Explain the following SQL function using a suitable example.
POWER()
