2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted by each vendor, who has submitted more than one invoice. Order by the number of invoices in descending order. Should return 12 rows. number of vendor name average_invoice_total min_invoice_total max_invoice total invoices Federal Exoress Corporation United Parcel Service Zvlka Desian Pacific Bel Malov Lithoarachina Inc Roadwav Packaoe Svstem. Inc Blue Cross Compuserve Inoram Data Reoroductions Coro IBM Cardinal Business Media. Inc. 47 93. 15 10.00 739.20 9 2575.33 1927.54 3813.33 867.53 313. 55 1962. 13 46.21 28.50 16.33 23978.48 10976.06 37966. 19 10.92 6.00 25.67 188.00 116.00 224.00 9.95 9.95 9.95 1077.21 579. 42 1575.00 2. 10963.66 85.31 21842.00 1083. 58 600.06 116. 54 90.36 132.68 175.00

Q: Write a SQL query that displays the number of customers who born on the 16th day of a month .  Write…

A: 1. select count(customerID) from Customers where to_char(custDOB,'DD') = 16; 2. select customerID…

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: Write a SELECT statement that returns the companyname, address, city and postalcode from the…

A: We need to display companyname, address, city and postalcode from the suppliers table Tables needed:…

Q: Table Name: CUSTOMERS FIELD NAME DATA TYPE CONSTRAINT DESCRIPTION (do not include this in the CREATE…

A: SQL Command to add validation in CTYPE attribute of the table CUSTOMERS is: Alter Table Customers…

Q: Get a list of visit reasons of which the average cost is greater than 2000 but less than 2050. •…

A: The SQL Query to extract the given output is: SELECT VisitReason, AVG(Cost) AS “avgcost” FROM visit…

Q: Create a query for displaying average commission percentage company is giving to its employees.…

A: Format of Query :- SELECT AVG ( coloum name ) AS aliasname FROM tablename; According To question :-…

Q: Exercise: Create a statement that will add the following row to the invoices table: 115, 1,…

A: Please find the SQL query's for the questions in the below steps.

Q: Which clause can be used to limit or filter the groups returned by a query that utilises a group…

A: To be determine: Which clause can be used to limit or filter the groups returned by a query that…

Q: Which clause can be used to restrict or filter the groups returned by a query based on a group…

A: Clause used to restrict the groups: The GROUP BY function is a SQL command that is used to group of…

Q: must be in SQL SSMS format /*29. Write a trigger to update the CUST_BALANCE ON CUSTOMER TABLE when…

A: It is defined as a relational database management system based on the Structured Query Language,…

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: In SQL, the WHERE clause to the SELECT statement states the criteria that must be met: Multiple…

A: EXPLANATION: SQL is a database language that allows you to store, manipulate, and retrieve data.…

Q: please use the picture below to answer the following question Display employee number, employee…

A: SELECT EmployeeID, Emp_LName, HireDate FROM Employee e JOIN Position pWHERE e.Emp_LName like '%e%'…

Q: Q. Based on the given table, solve the following queries. a) Write the SELECT command to display…

A: Note:- "since you have posted multiple questions and according to our guidelines we are authorized…

Q: enter null value in a column where the Unique constraint is assigned to that column

A: enter null value in a column where the Unique constraint is assigned to that column True or False

Q: Examine this product table's column definitions: pid number primary key pname varchar2(50) You must…

A: The Select statement is used in SQL to obtain a subset of rows and columns in a database. The…

Q: Display all customers regardless of orders and also display orders for each customer.

A: Query to display all the customers that have placed an order and those that have not placed the…

Q: 10- What the output of the following query? SELECT name From STORE where job='mgr'

A: Consider the query SELECT name From STORE where job = ‘mgr’ The query will select all rows of the…

Q: Create an UPDATE query that lowers the daily rental rate of sailboat rentals by 10%.  Note: show me…

A: Solution: As per the given information in the question.   The query is listed below as per the given…

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 in SQL a command that creates the table Customers according to the above description (2…

A: SQL answers to the above first 3 questions are in step2 as per our guidelines we are supposed to…

Q: Which clause can be used to restrict or filter the groups returned by a group function- based query?

A: To be determine: Which clause can be used to restrict or filter the groups returned by a group…

Q: Task 9: Use a subquery to find the sales rep ID, first name, and last name of each sales rep who…

A: According to the question here we will choose in statement while writing the subquery. The subquery…

Q: Create table customer1( Customer# number primary key, First_name varchar2(25, Last_name…

A: Please find the answer below :

Q: 3. Using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from…

A: Using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from the…

Q: Create a stored procedure that will list all customers (name and number) represented by rep 15

A: create table cust_records(cust_num int primary key,cust_name varchar(30));insert into cust_records…

Q: Insert two records in each table or use if you have already created this schema. Q#2 Display…

A: For this question we have to write the queries for required 10 question. All these queries include…

Q: Select Invoice_number, invoice_due_date, payment_date and the number of days late for those invoices…

A: Note: The given query has been compiled and executed in "sqlfiddle" online compiler. Creating an…

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: Because the SELECT clause contains the Customer* column, which clause must be included for the query…

A: Clause used in the query The SELECT statement returns a result set of records from one or more…

Q: Teomdate Display guest details who paid total charges RS.50000 and above. Write a query to fetch…

A: To write a query to fetch Guest id, Guest name and Sum of total charges. Give alias name to total…

Q: Q#1 Print the name of players who played any tournament organized by “hafiz asif”. (Nested Queries)…

A:

Q: Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id) Which of the…

A: query that will is: select e.last_name from employees e, employees m where e.manager_id =…

Q: Use the following table to answer the questions below: Table name: Customers Column Name Role Data…

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

Q: Task 19: List the REP_ID and the corresponding sum of the balances, as BALANCE, of all customers for…

A: List the REP_ID and the corresponding sum of the balances, as BALANCE, of all customers for each…

Q: e_id column as Invoice_ID The invoice_date column as Invoice_Date The invoice_due_date column as…

A: Lets see the solution.

Q: Modify the SELECT statement to select the title and release date of PG-13 movies that are released…

A: Answer:

Q: Use the following table to answer the questions below: Table name: Customers Column Name Role Data…

A: Create a table Customers with the below query: create table Customers(customerID char(5) PRIMARY…

Q: PLZ HELP WITH THE FOLLOWING: make the following work select MOVIE_NAME, MOVIE_YEAR from MOVIE…

A: Given,    List movie title and movie year for movies that have a movie cost is greater than…

Q: PLZ hlp with the following: In SQL If you add the PRIMARY KEY constraint to a column, you must…

A: SQL is a standard language for storing, manipulating and retrieving data in databases. SELECT -…

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: Examine this product table's column definitions: pid       number    primary key pname…

A: Given Examine this product table's column definitions:   pid number primary key pname varchar2(50)…

Q: Produce a script file with 15 queries: At least two using join At least three using where clause At…

A: The JOIN clause is used to combine more than one different table based on the condition which is…

Q: use the following picture to answer question below question 10

A: Given, CUSTOMER(CUSTID, LNAME, FNAME, CITY, STATE, PHONE) The default value is assigned to column…