For every order that has been received, display the order ID, the total dollar amount owed on that order (you’ll have to calculate this total from attributes in one or more tables; label this result TotalDue), and the amount received in payments on that order (assume that there is only one payment made on each order). To make this query a little simpler, you don’t have to include those orders for which no payment has yet been received. List the results in decreasing order of the difference between total due and amount paid.

Q: For each order, list the order ID, customer ID, order date, and most recent date among all orders.…

A: Given data For each order, list the order ID, customer ID, order date, and most recent date among…

Q: Write a query to produce the total number of hours and charges for each of the projects represented…

A: A query is a way to give instruction to the server to extract data from database. In SQL, SELECT…

Q: Working with the Orders table, the OrderDate and ShipDate are not in the correct MYSQL format, the…

A: SQL queries approach:     1- The first query required the DATE_FORMAT function.2- With the help of…

Q: Use a subquery to find employees' last names and hire date from the employees table whose manager is…

A: Let us see the answer:-

Q: Using OrcalTal Show all item num and item descriptions from the item table, and a matching num…

A: Answer: Oracle table query: create table items(itemno int not null primary key,itemdesc…

Q: Use a query to compute the total of all purchases, the number of purchases, and the average purchase…

A: Step 1. Table creation: Step 2. Inserting values: Step 3. Display the table: Step 4. To calculate…

Q: Complete the query to get the EmpFname from the EmployeeInfo table in the upper case using the alias…

A: Given, We have to complete the given query to get the EmpFname from the EmployeeInfo table in the…

Q: Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database, write the SQL code…

A: Using the EMPLOYEE, JOB, and PROJECT tables in the Ch07_ConstructCo database, write the SQL code…

Q: Write a query to produce the total number of hours round to 1 digit and charges round to  2 digits…

A: The Sql Query corresponding to the above problem is solved as :   SELECT Proj_Num,…

Q: Write a query to list clients ID, book number and days kept for each check out. Note: days kept is…

A: Below are the two commands that you can try: 1. Select PATRON.PAT_ID, BOOK.BOOK_NUM,…

Q: Which restriction may be used to ensure that a book's category is included when it is added to…

A: Introduction: Inventory refers to the raw materials utilized in manufacturing and the finished…

Q: Add the OWNER_NUM column as a foreign key in the CONDO_UNIT table.

A: to Add the OWNER_NUM column as a foreign key in the CONDO_UNIT table, the script is mentioned in…

Q: Write a query to display the patron ID, book number, and days kept for each checkout. "Days Kept" is…

A: In SQL, to calculates the number of days between two dates, DATEDIFF() function is used. It retrieve…

Q: i. Insert all rows from Product table into Parts table by using subquery. ii. Find the average of…

A: SELECT query will fetch the result and the same will be inserted to another table using INSERT query…

Q: Write a query that returns the mean cost per install for each adgroup as well as the percentage of…

A: the answer is given below:-

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: List all ‘Assistant’ and add 500 to their salaries, also change the column heading to Salary With…

A: Sol 1: Since here table name is not given. So, we are assuming the table name as name_of_table. To…

Q: For each different job_id group in the employee table, show the average salary and job_id for the…

A: SELECT Average_salary,              Job_id  FROM employees  WHERE EXISTS (SELECT *…

Q: Rewrite the query to be more specific. choose * from the natural section and then join the…

A: In SQL query, natural join is a type of equi joins constructed so that columns from related tables…

Q: Add a CHECK constraint on the BEDROOOM column in the ROOMS table. It must accept a value from 1 to 5…

A: CHECK is the keyword used for CHECK constraint and after table has created, if you want to add this…

Q: Using the output shown in Figure P7.12 as your guide, generate a list of customer purchases,…

A: Here we have to write an SQL query to have the given table/list of data in the fig. P7.12, Key…

Q: Using the data in the ASSIGNMENT table, write the SQL code that will yield the total number of hours…

A: Actually, SQL  is a language to operate databases in searching and filtering the data according to…

Q: What will be the field size for the ProductLineName field in the Product table? Why?

A: The field size is 40.

Q: The query to join the P_DESCRIPT and P_PRICE columns from the PRODUCT table and the V_NAME,…

A: Given: The query to join the P_DESCRIPT and P_PRICE columns from the PRODUCT table and the V_NAME,…

Q: EMPLOYEE, and PROJECT tables using common attributes. Sort the results by project value.  In the…

A: Given:- Using the EMPLOYEE, JOB, and PROJECT tables in Figure P7.1, write the  SQL code that will…

Q: Change the MONTHLY_RENT column in the LARGE_PROPERTY table to reject null values

A: You can insert NULL value for a data and you can restrict that it shouldn't allow null values by…

Q: Write a query that uses INNER JOIN TO connect the EMPLOYEE, EMPPROJACT, PROJACT and PROJECT tables.…

A: The INNER JOIN is also referred as EQUIJOIN.The EQUIJOIN creates a new result table by combining…

Q: If a combination of values of all the key attributes is included in the query, how many tuples will…

A: If a combination of values of all the key attributes is included in the query, Then Single tuples…

Q: Write a query to display the patron ID, last name, number of times that patron has ever checked out…

A:

Q: Using the relations in the appendix, write the following queries in  SQL: i. Display a list of all…

A: (i) The required query is: SELECT ID, COUNT(section_id, semester) as 'Count of Sections Taught'FROM…

Q: Using a subquery in the FROM clause, find the average unit price of in-stock trucks of any…

A: Required SQL query is given below:

Q: Question 7 is subquery expression included in the attribute list that must return one value. IN a.…

A: We are asked out of 4 given sql clauses which one will throw one value only..

Q: Open the AttendeeFirstName query in Design View and add criteria to select only those records where…

A: According to the question , we have to write a SQL Query according to given criteria. In step 2, we…

Q: List all products with their highest unit price, i.e. not discounted. the database is

A: Given: List all products with their highest unit price, i.e. not discounted.the database is

Q: Write a query to display the patron ID, book number, and days kept for each checkout. “Days Kept” is…

A: NOTE: - AS THE SCHEMA WASN’T PROVIDED, THE NEW SCHEMA IS ASSUMED WITH THREE RECORDS.Select is used…

Q: Rewrite the query below to also show INDATE as [Stock Date]: SELECT PRODUCT.P_CODE,…

A: I have given an answer in step 2.

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: Use KimTay Pet Supplies Database For each invoice, list the invoice number and invoice date along…

A: SQL We communicate with a relational database that use the computer language known as Structured…

Q: Q1. B. Consider the Following Table Employee(emp_id, name,dept_id, email, mobile_number,…

A: Given: To write the SQL Query.

Q: Write a query to display each department's name, location (Name of the City), number of employees,…

A: We have to group the data by the department name and then calculate number of employees in that…

Q: Modify the CUSTOMER table to include the customer’s date of birth (CUST_DOB), which should store…

A: Modifying table Alter statement is used to modify column, add constraints, add columns, drop…

Basic SQL Queries

Structured Query Language is the full form of SQL. It is a high-level language used to communicate with a relational database. It is used for creating, storing and accessing contents of a relational database. SQL is used to write the queries which are executed using database engines like Oracle, SQL Server and so forth.