Advertisements
Advertisements
प्रश्न
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;
Advertisements
उत्तर
- SELECT Department, avg(salary) FROM Teacher GROUP BY Department;
Department Avg(Salary) Computer Sc 16500.00 History 30000.00 Mathematics 25000.00 - SELECT MAX(Date_of_Join), MIN(Date_of_Join) FROM Teacher;
Max(Date_of_Join) Min(Date_of_Join) 2021-09-05 2017-03-04 - SELECT Name, Salary, T.Department, Place FROM Teacher T, Placement P WHERE T.Department = P.Department AND Salary>20000;
Name Salary Department Place Randeep 30000 Mathematics Jaipur Samira 40000 History Ahmedabad Raman 25000 Mathematics Jaipur Shyam 30000 History Ahmedabad Shiv 21000 Computer Sc Nagpur - SELECT Name, Place FROM Teacher T, Placement P WHERE Gender = 'F' AND T.Department = P.Department;
Name Place Samira Ahmedabad Suman Ahmedabad Shalaka Jaipur
APPEARS IN
संबंधित प्रश्न
The MAX () function finds the
Assertion (A): COUNf function ignores DISTINCT
Reason (R): DISTINCT ignores the duplicate values.
Which of the following is not an aggregate function?
The char() function in MySql is an example of ______.
Identify Single Row function of MySQL among the following.
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 length(trim("ABC Public School")) = ______.
Name a function of MySQL which is used to remove trailing and leading spaces from a string.
Name a function of MySQL used to give position of the first occurrence of a string2 in string1.
What will be returned by the given query? SELECT INSTR('INFORMATIONFORM', 'FOR') = ______.
Which statement is used to count the number of rows in table?
Write the name of the functions to perform the following operation:
To display the day like “Monday”, and “Tuesday”, from the date when India got independence.
Write the name of the functions to perform the following operation:
To display the specified number of characters from a particular position of the given string.
Write the output produced by the following SQL statement:
SELECT ROUND(342.9234, -1);
Write the output produced by the following SQL statement:
SELECT LENGTH("Informatics Practices");
Differentiate between count() and count(*) functions in SQL with appropriate examples.
Which one of the following is not an aggregate function?
In SQL, which function is used to display the current date and time?
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:
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.
POWER()
