The company wants to see the total sale amount per sales person (salesman) for all orders. Assume that online orders do not have any sales representative. For online orders (orders with no salesman ID), consider the salesman ID as 0. use the sql and the following data as shown to Display the salesman ID and the total sale amount for each employee. Sort the result according to employee number.

Q: Use the given database to output the results of the following SQL queries: a.)  SELECT building,…

A: Query: /*Creating tables*/ CREATE TABLE classroom (   building TEXT,   room number INTEGER,…

Q: Write a SQL statement that shows vendor name, vendor area code and vendor phone number for vendors…

A: SELECT V_Name, V_AreaCode, V_Phone FROM VENDOR WHERE V_State = 'TN';

Q: Using the university schema, write the following SQL queries. Find the lowest per-department maximum…

A: The syntax for the MIN function in SQL is:   SELECT MIN(aggregate_expression) FROM tables [WHERE…

Q: What is the difference between COUNT, COUNT DISTINCT, and COUNT(•) in SQL? When will these…

A: Given: What is the difference between COUNT, COUNT DISTINCT, and COUNT(•) in SQL? When will these…

Q: Write an SQL query to answer the following question: Is any instructor qualified to teach ISM 3113…

A: SQL QUERY:-

Q: Using the university schema, write an SQL query to find the names and IDs of those instructors who…

A: Given: Using the university schema, write an SQL query to find the names and IDs of those…

Q: Write SQL query to fetch the Name of all employees working in IT department from table…

A: Write SQL query to fetch the Name of all employees working in IT departmentfrom table Employee(Name,…

Q: Write the following queries in SQL, using the university schema. For each department, find the…

A:

Q: QI/ By Using the following schema, answer the following SQL queries and commands:…

A: below are the queries

Q: Answer this following question using SQL Statement. From table STUDENT : Write a SQL Query to show:…

A: 1. select first_name, last_name, address from student where address='Ampang';               2.…

Q: Write an SQL query to answer the following question:Which students were not enrolled in any courses…

A: sql>select studentname,rollno from studenttable where course is null and semester=1 and…

Q: Write down the SQL to show the average salary for each department together with its department name…

A: CODE: SELECT department_name, AVG(salary), COUNT(commission_pct) FROM departments JOIN employees…

Q: Write a SQL query to find the number of students in the school from the table:  Students (RollNo.,…

A: Given Table: Students (RollNo., Name, Father'sName, Class, Mobile No., Address) To Find: Count of…

Q: Write a SQL query to calculate the total purchase amount of orders that have an even ID number

A: SQL Query are very useful to fetch the required data from database in the table form In this…

Q: Answer the query using SQL. For each department which has more than 5 female employees, retrieve the…

A: In the following Query we will retrieve three things: The department name The number of female…

Q: underlined. Give an expression in SQL for each of the following queries. Employee(ID, name, age,…

A:

Q: List all book information for the book or books which sold for the average price of all books sold…

A: We need to display all book information for the book or books which sold for the average price of…

Q: Write a SQL statement to count all the records from STUDENT table per department and arrange in…

A: Here we need to form group of each department and count number of student in each department. For…

Q: Write an SQL query to fetch the no. of workers for each department in the descending order.

A: Question. Write an SQL query to fetch the no. of workers for each department in the descending…

Q: I can not seem to get this SQL to work with out errors: SELECT CUSTOMER_NUM,LAST_NAME,FIRST_NAME…

A: Whenever we are trying to join two tables, then in that case we give an alias to the table name. An…

Q: Write SQL queries to answer the following questions:a. How many students are enrolled in Section…

A: GIVEN: Write SQL queries to answer the following questions:a. How many students are enrolled in…

Q: Write the following queries in SQL, using the university schema. Find the lowest, across all…

A: Query for selecting minimum salary The select statement is used to select data from a database.…

Q: Using the university schema, write an SQL query to find the name and ID of each History student…

A: Introduction:  Structured Query Language is abbreviated as SQL, or is also pronounced as See-Qwell.…

Q: Write a SQL statement to count all the records from STUDENT table per department and arrange in…

A: To group the table as per department, use GROUP BY clause.  To arrange the record in ascending…

Q: Write SQL query to increment SALARY of all employees by 100 whose current SALARY is 1000 in the…

A: Given: Employee(EID, ENAME, DEPARTMENT, SALARY) Requirement: Increment salary of all employees by…

Q: You have a table Employee(empID,name,salary,dno). Dno is department number to which employee…

A: Algorithm :  Step 1 : select the sum of salaries payed for the employees department wise.

Q: Provide SQL queries and the result table for: 1. Sales of which artist’s works have resulted in the…

A: Provide SQL queries and the result table for: 1. Sales of which artist’s works have resulted in the…

Q: */By Using the following schema, answer the following SQL queries and commands:…

A: ANSWER:- SEE STEP NO 2

Q: By using this table answer this question in SQL:   Show the department id, department name and the…

A: Given: Show the department id, department name, and the number of employees working in any…

Q: List the item ID, description, and number of units on hand for each item that has between 10 and 30…

A: Here I have created the ITEMS table and inserted dummy data into it. Please let me know if any…

Q: lease ensure that you include the result table as well as your SQL; Calculate the profit made on…

A: "As per the Bartleby policy, we can solve one question at a time if need rest of solution please…

Q: 1.1 Print a list of all workers, ordered by job and then by age (from young to old). 1.2 Except for…

A: As per our guidelines we are supposed to answer only 3 sub-parts, please repost the remaining…

Q: Using the university schema, write an SQL query to find the ID and name of each instructor who has…

A: SQL(structured query language) is used in relational databases to query information and manipulate…

Q: please show the step Simplify the following SQL query. SELECT         EMP# FROM             EMP…

A: I have provided the explanation of the given SQL query in step 2.

Q: Write the SQL query to get the order number, order date, customer name, shipped date, and sales…

A: Since the data spans the following tables -orders -orderdetails -products -productlines -customers…

Q: Using the university schema, write an SQL query to find the names and IDs of those instructors who…

A: SQL queries are written to fetch records from databases that are composed of several relations.…

Q: 6- Find Customer ID, Customer name and the number of loans for each Customer.

A: As per our guidelines we are supposed to answer only one question. Kindly repost the remaining…

Q: Write the following queries in SQL: Display the list of all course sections offered in Spring 2018,…

A: Here, we will use a SELECT statement to display the required result set along with the decode…

Intermediate SQL Concepts

A query is a request for data or information from one or more database tables. This information could be presented in the form of pictorials, graphs, or complicated findings which helps in easy interpretation. Structured Query Language (SQL) is the most widely used programming language for retrieving and organizing data from relational databases. Collection of tables with rows and columns is referred to as a database. SQL is the language of databases. It makes it easier to extract specific data from databases, which can then be used for analysis.