Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500? a) select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null; b) select job, sum(Sal) from Emp where comm is null group by job having sum(Sal) > 2500; c) select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null group by job; d) select job, sum(Sal) from Emp group by job having sum(Sal) > 2500 and comm is not null;

Q: In which clause should you include the condition MAX(cost) > 39 to restrict groups displayed in…

A: The HAVING clause is used with the aggregated functions. examples of aggregated functions are sum,…

Q: Q2: Do these queries: 1. Show department name and instructor name who is having salary greater than…

A: Due to company policies I am compelled to solve only one question and that is the first question.…

Q: Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.   Expected…

A: Required: Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.…

Q: Question 2. Which of the following operator can be used between main query and subquery?

A: solution provide in second step

Q: Which query determines the customers who have ordered the most books from JustLee Books?  (refer to…

A: Query The query that determines the customers who have ordered the most books from JustLee Books is…

Q: Which line of the SELECT statement is used to group data stored in the database?…

A: Explanation: The select statement is used to group data stored in database is GROUP BY. GROUP BY…

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: Solve the following queries:

A: Find the following queries in MySQL: Display all details of the item table. Select * from item;…

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: Show the last name, the trip id, and arrival town of those pilots who have flown with more than 450…

A: Consider pilots table and it contains the attributes last name, trip id, arrival town, airport name.…

Q: List student names and total reservations for all students whose have reservad a book more then one…

A: SQL Query: select s.sname and count(r.sid) from student as s, reservation as r, book as b where…

Q: Which query returns the first 3 characters of last name of the manager who work with employee named…

A: Basic knowledge of SQL is required to solve this problem.

Q: FROM SALESPERSON WHERE SPNUM= (SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772): What is this subquery…

A: Given subquery SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772

Q: select first name of customer  and the highest total in invoice in sql

A: The highest of any column can be obtained by using max operator select is used to display the data

Q: Select clause and from clause: Display the columns specified above in the problem  statement from…

A: Write a query to display the author ID, first name, last name, and year of birth for all authors…

Q: Which line of the SELECT statement is used to restrict groups displayed in the query results?…

A: Select statement The select statement is used to select data from a database. The data returned is…

Q: Write a query to generate the total number of invoices, the invoice total for all of the invoices,…

A: Built-in functions: Structured Query Language (SQL) has some built-in functions and they are:…

Q: SQL queries

A: According to the question, we need to write the SQL queries of the following questions: Write a…

Q: create a subquery. (sql)   Query employee name, phone number, job name, salary. In addition, get…

A:

Q: Write a query to display the customer code, customer first name, last name, full address, invoice…

A: For this query we should use Group By and Order By clauses to group the state name and sort by…

Q: Write Queries for the following: a. List all student whose Surname begins with b or end with a or…

A: Question 3 is answered as per the guidelines, please repost other questions. The data inserted into…

Q: Which of the following queries displays name and code of courses with a section more than 50…

A: Attribute name and course belong to table Course. In option (A) and (D), we are trying to get these…

Q: Which of the following tables is followed by the outer join operator (+) in an OUTER JOIN query?

A: Given; Which of the following tables is followed by outer join operator in an OUTER JOIN query

Q: 1. Delete the customer(s) who not ordering. 2. Update CITY_NAME of CUSTOMER table for all customers.…

A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

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

A: In SQL, the SELECT statement can be applied to fetch records from any relation. It can display…

Q: •Create and load the Employee, Department and Titic Tavics: ton •Write Queries for the following:…

A: Since multiple queries have been asked to be answered, we will answer first three queries. If you…

Q: For every invoice, display the invoice number, invoice date and the total dollar amount for all…

A: Dear student  your query get the error because inv_number exist in the two table so you have to…

Q: Given the following ERD, which of the following joins produce the same results. You can assume the…

A: Here, there are three relations named A, B, and C which are shown using the ERD. In this ERD,…

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: Salary from highest to lowest  Sorting emp name alphabet

A: Please find the answer below

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

A: SQL program is an given below for the students :

Q: In the SQL Oracle Application, Within the Employees table, each manager_id is the manager of one or…

A: Answer: SELECT  manager_id, job_id, SUM(salary) "total salary", GROUPING(manager_id),…

Q: What do you want to retrieve by the following query? select LNAME, FNAME, SALARY from employee where…

A: As per the Bartleby guideline, the first question only will get solved. Please post the rest of the…

Q: Write the standard MYSQL query to retrieve the average customer balance grouped by SalesRepNo Write…

A: I have provided answers in step 2.

Q: SQL DATABASE need the SQL statements ATTACHED tables 3. List the reservation ID, trip…

A: Dear student, as per guideline I'm supposed to answer first three sub-parts in an order, i request…

Q: which order, are generated by your definitions for the queries: ?- brother (X,Y). ?- cousin (X,Y).…

A: i. grandson(X,Y) = father(Z, X), father(Y,Z)             grandson(X,Y) % 8 ii. brother(X, Y) =…

Q: If a subquery is used in the FROM clause of a query, how are the subquery’s results referenced in…

A: Results of a sub query used in FROM clause The FROM clause is used to list tables and any joins…

Q: c) Write the standard MYSQL query to retrieve the Name and CustNumber of customers with a balance…

A: In the question it is asked for retrieving the Name, But in the CUSTOMER table there is column name…

Q: What will be the output of the given queries on the given table shown below: Student(SID,…

A: Given Table: Student(SID, NAME,CLASS, SECTION) Requirement: Find the output when the following query…

Q: Write a SQL query to find the customer# of those customers that purchased at least once in July 2020…

A: The problem is to find number of customers of those customers who purchased at least once in July…

Q: List the customer ID and first and last names for all customers located in the city of Cody. Your…

A: Convert the city to upper case and then check  whether city is CODY or not

Q: Select all rows from the Orders table where the CustomerID is 400 or 500

A: I have provided an answer to this question in step 2.

Q: mber in descending order and then by invoice date in ascending order. Here you will use an aggregate…

A: SQL: For every invoice, display the invoice number, invoice date and the total dollar amount for all…

Q: Find the output of the following query based on the table given below. SELECT AVG(fees), course_id…

A: here have to determine correct option for SQL statement.

Q: Select all rows from the Orders table where the CustomerID is greater than 300.

A: Syntax: SELECT column1, column2, ...FROM table_nameWHERE condition;

Q: I can't figure out the SQL Because BITS is about to obtain client number 1000, increase the length…

A: Please find the answer to the above question below:

Q: Write a query that returns all customers listed in the orders table who placed orders on the most…

A: The answer is given below.

Q: Which one of the following SQL select statements will display a list of all vendors that do not yet…

A: select vend_code, vend_name from vendor where vend_name IS NULL;

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.