What do you want to retrieve by the following query? select LNAME, FNAME, SALARY from employee where SALARY > some (select SALARY from employee where DNO = 5):

Q: what value will be retrieved by the following query? TEMP - SELECT from X where B>C

A: Correct answer is 4, 4, 2

Q: a). Write a query to get the list of employees who joined during the years 1990 and 1991.

A: TO_CHAR Function : TO_CHAR function is used to typecast a numeric or date input to character type…

Q: What will be the result of the following query? SELECT count(*) FROM enrollment GROUP BY courseid;

A: query :  SELECT COUNT(*) FROM enrollment GROUP BY courceid; ans-> A - numbers 3 and 1  AMG ->…

Q: Write a query that displays name of employee and commission for all employees who have been employed…

A: select ename,nvl(to_char(comm),'NO COMM') as comm,round(months_between(sysdate,hiredate))as…

Q: how to write a query using a subquery to list InvoiceNumber, InvoiceDate for those products with a…

A: A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within…

Q: Assuming that this query displays the Employees whose first name starts with letter A, which…

A: Since we can answer only up to 1 question. So we'll answer the first question. Please resubmit the…

Q: Write a query to find the name of employees that begin with alphabet 'A'

A: Given, In SQL we need to write a query that finds the name of employees that begin with the…

Q: Write a query to list the first name and last name of all authors. Concatenate the first and last…

A: The SQL query is: SELECT CONCAT(CONCAT(firstname,' '),lastname) AS FullName FROM author;…

Q: Use sub queries to answer the following Q1) write a query to display the employees first name and…

A: Note:- since table name is not we had given queries according to question given Syntax:   select…

Q: ​Create a Query with all products information whose price is >20.

A: Lets see the solution.

Q: Create a Query with all products information whose price is >20.

A: Lets see the solution.

Q: Q1: Write a query to find the students working in a company   having more ratings than their seniors

A: select student_name from EMPLOYEES RATING TABLE where designation != senior and rating >= 9

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given in the above question we have to create a SQL code to display the resort Id, the total  count…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given in the above question we have to create a SQL code to display the resort Id, the total  count…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given in the above question we have to create a SQL code to display the resort Id, the total  count…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given in the above question we have to create a SQL code to display the resort Id, the total  count…

Q: Write a query to display unique student ID who joined in the month of June. Sort the result in…

A: As per the above listed problem statement we have to develop a SQL code to display unique student ID…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given in the above question we have to create a SQL code to display the resort Id, the total  count…

Q: Given the following table TABLE CUSTOMER Column Null? Туре CUS_ID NOT NULL NUMBER NAME VARCHAR2(50)…

A: B. SELECT cus_id "Customer_id", name From customer: It will  show error due to "Customer_id". C.…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given in the above question we have to create a SQL code to display the resort Id, the total  count…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given in the above question we have to create a SQL code to display the resort Id, the total  count…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given, We have to write a query to display the resort Id, the total count of guests stayed as…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given Information: In this question we have to create a SQL query to show the resort Id, the total…

Q: Write a query to display maximum bus tickets fare and give an alias name as MAXIMUM_AMOUNT

A: We use SELECT statement for selecting the data from relational database, the result will be stored…

Q: Write a query to display maximum bus tickets fare and give an alias name as MAXIMUM_AMOUNT

A: Here, Query instruction is given.

Q: Write a query to display maximum bus tickets fare and give an alias name as MAXIMUM_AMOUNT

A: Given: Write a query to display maximum bus ticket fare and give an alias name as MAXIMUM_AMOUNT

Q: Write a query to display maximum bus tickets fare and give an alias name as MAXIMUM_AMOUNT

A: GIVEN: write a query to display maximum bus ticket fare and give alias name as MAXIMUM_AMOUNT

Q: Complete the query to get the number of employees working in the department ‘HR’.       ______…

A: Given, We have to complete the given SQL query to get the number of employees working in the…

Q: Write a query to display unique student ID who joined in the month of June. Sort the result in…

A: There are two alternatives for this solution considering studid is available in both the tables.

Q: Write a query to display the number of people with the same job. JOB ID COUNT() AC_ACCOUNT AC_MGR AD…

A: Here, we have to group the employees based on the job_id and then count the number of employees in…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given in the above question we have to create a SQL code to display the resort Id, the total  count…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given in the above question we have to create a SQL code to display the resort Id, the total  count…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given in the above question we have to create a SQL code to display the resort Id, the total  count…

Q: Write a query to get the total salary paid to all employees since the start of the company.

A: The query in MySQL will be: mysql> select sum(salary) from employees e, salaries s, dept_emp d…

Q: Write a query against the Sales.Orders table that returns orders placed in June 2015.

A: - We need to write the query for the provided problem of data selection.

Q: Write a query to display unique student ID who joined in the month of June. Sort the result in…

A: Write Query to display unique student id who joined in month of june .sort the result in ascending…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: According to the question below the solution:

Q: write a query to find the last_name that is 4th from the bottom using subquery. (you need to use…

A: In SQL, to select the specific number of records SELECT TOP clause is used. To get the record from…

Q: Write the following queries. 1. Write a query to get the First Name and Last Name of all employees…

A: As per company rules experts are only supposed to Solve one question.So kindly post another…

Q: The sales person gets a bonus pay if their amount exceeds a certain tier level for each year. Write…

A: Here we need to join the relation Training and BonusPay.  They have common attribute ID. Thus we can…

Q: Write a query to fetch details of employees whose EmpLname ends with an alphabet ‘A’ and contains…

A: Given, 'EmpLname' is the column name of the table. The last name of the employee ends with the…

Q: Write a query to display student Id who registered for the course 1001, 1005. If they registered for…

A: Required: We have to write a sql query to display student Id who registered for the course 1001,…

Q: Write a query to display student Id who registered for the course 1001, 1005. If they registered for…

A: Required: We have to write a sql query to display student Id who registered for the course 1001,…

Q: Write a query to display student Id who registered for the course 1001, 1005. If they registered for…

A: The SELECT DISTINCT statement is used to return only distinct (different) values.

Q: Write a query to retrieve name of professor, department name and project, for all projects whose…

A: 1.  select professors.name as professorName, departments.name as departmentName, Projects.name as…

Q: Run a query or multiple queries if needed to report on final exam average based on the student’s…

A: Display Average FinalExamGrade for age < 40: Select avg(FinalExamGrade) From…

Q: Write a query to display the total inventory—that is, the sum of all products on hand for each brand…

A: “SELECT” statement: It is used to retrieve information from the table or database. The syntax for…

Q: Write a query that will group identical movie categories together. The table name is Movies.

A: Creating table movies:   Table name- movies

Q: Write a query to display the guest names who are from Ooty. For instance, the guest name 'geeta…

A: Information Provided: According to the problem statement provided we should upgrade the SQL query to…

Q: The query that displays birth date of employee whose ssn = 123456789 in format 'Saturday…

A: to_char() is used to format output in specified format  Day Month/dd/Year is the format to get…