Register Now

Login

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Category : SQL

SQL related questions

Question
What will be the output of following sql query SELECT     name,         last_name,         salary FROM Salary WHERE salary >    (SELECT AVG (salary)                     FROM Salary);
in progress 0
55 years 1 Answer 1020 views Newbie

Question
Q5. Working with the “employees” table, select the data about all individuals, whose first name starts with “Mar”; specify that the name can be succeeded by any sequence of characters.   Emp_id First_name Last_name Sex Hire_date 1 Mark Johnson M 2021-06-27 2 Marcus stoniss M 2020-05-04 S3 Babita Iyer  F 2021-06-18 4 Jethalal Gada M 2019-07-16 5 Neymar Chapel M 2019-08-09 6 Atmaram Bhide M 2018-09-10 7 Daya Gada F 2020-06-07  
in progress 0
55 years 1 Answer 851 views Member

Question
Q4.     Extract the information about all department managers who were hired between the 1st of      January 2020 and the 1st of January 2021.   DEPARTMENT MANAGER Emp_id First_name Last_name Sex 1 Aman Rathore M 2 Gaurav Singh M 5 Goli Beta M 7  Natu Kaka M     EMPLOYEES Emp_id Emp_name Hire_date 1 Aman 2021-06-27 2 Gaurav 2020-05-04 3 Rohit 2021-06-18 4 Vimal 2019-07-16 5 Goli 2019-08-09 6 Shivam 2018-09-10 7 Natu 2020-06-07
in progress 0
55 years 1 Answer 1076 views Member

Question
Q3.you have given a tabled name “Department”.  Write a query to replace “not provided” where there is null in the below table and then show the department manager column.   Dept_no Dept_name Dept_manager D001 Marketing Aman D002 Finance Ashika D003 Human resource Abhishek D004 Production Vivek D005 Research Null D006 Sales Null D007 Customer care Null
in progress 0
55 years 1 Answer 840 views Member

Question
Query the list of CITY names from STATION that does not start with vowels and do not end with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude.
in progress 1
55 years 1 Answer 3412 views Newbie