Find the rep number, last name, and first name of each sales rep who represents at least one customer with a credit limit of $10.000

Q: LIST THE FIRST AND LAST NAMES OF ALL OWNERS WHO OWN A TWO-BEDROOM PROPERTY. USE THE IN OPERATOR IN…

A: Considering there are 2 tables:-  OWNER: which holds the OWNER_NUM, FIRST_NAME, and LAST_NAME…

Q: Insert into the LARGE_PROPERTY table the office number, address, bedrooms, floors, monthly rent, and…

A: We need to insert some columns from property table to largeproperty table whose square footage is…

Q: Based on the ERD below, display the assignment number, employee number and assigned hours for either…

A: Here we are joining three tables ASSIGNMENT, EMPLOYEE, and JOB and the assigned job is either 501 or…

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: 4. List all customers (last name, first name and zip code) whose zip code is missing (unknown).

A: 4. Answer: SELECT LastName, FirstName, ZipCode FROM Customer WHERE ZipCode IS NULL;

Q: List the number of customers living at each state that is included in the Customer_T table.

A: Query:-

Q: SQL 1.Show the first name of employees and their related department name. 2.For each employee,…

A: Given: SQL 1.Show the first name of employees and their related department name. 2.For each…

Q: List the LastName, FirstName, and the total number of orders placed by each customer (as OrderCount)…

A: SQL is a structured query language, that's designed to facilitate the extraction the specific…

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: PRODUCTS PID DESC PRICE SID QTY 801 Pencil 3 1 10 802 A4 6 2 15 803 Ballpen 4 2…

A: GIVEN: PRODUCTS PID DESC PRICE SID QTY 801 Pencil 3 1 10 802 A4 6…

Q: See the following table CREATE TABLE product ( product_id NUMBER(3), product_name VARCHAR(30) NOT…

A:

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: Query list of all our customers full name and email. Show those whose customer id is either…

A: The above question is solved in step 2:-

Q: NOTE; language SQL List the office number, address, and monthly rent for properties whose owners…

A: Database: A database is used to store a huge amount of data records. Generally, most industries or…

Q: Find the number of (unique) products that have been sold to more than 10 customers.   SQL Question

A: We need to write a SQL query for finding the number of (unique) products that have been sold to more…

Q: For each reservation for customer Ryan Goff , list the reservation id, trip id and number of…

A: AND Operator: In Structured query Language (SQL), "AND" keyword is used in order to check two and…

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

A: SQL code The SQL code for getting employee number, employee last name, sum of assigned hours and…

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: Answer the query using SQL. For each department that controls more than 3 projects, retrieve the…

A: Introduction of DBMS: A database is a collection of data that are used to produce useful information…

Q: For every completed or 'open service request for janitorial work', list the condo id, description,…

A: The querry has given

Q: How can you concatenate columns in a query?

A: To concatenate the columns in a query.   In the SQL,   You can concatenate two or more columns in a…

Q: List the owner number and last name for all owners located in the city of Seattle. Your query should…

A: Actually, database is a used to stores data\information.

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: For each customer, list the CustomerID and the total number of orders placed in 2015.

A: Answer: Query: select Order_T.Customer ID,sum(OrderLine_T.Ordered Quant from OrderLine_T inner join…

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: Delete all the employees in the department that has less than 3 employees using sql

A: Explanation: The deletion is based on “DEPTNO” in “EMPLOYEE” table. “delete” command is used to…

Q: Find out the customers with balance of $3500 or more. Your result should include the most recent…

A: SELECT INVOICE .INV_NUM  WHERE TOP INVOICE .INV_DATE  DESC, INVOICE .CUST_CODE FROM INVOICE,…

Q: List the names of all customers that have a credit limit of $7,500 or less

A: Below is the answer to above question. I hope this will be helpful for you...

Q: Write the SQL code to validate the ASSIGN_CHARGE values in the ASSIGNMENT table. Your query should…

A: Write the SQL code to validate the ASSIGN_CHARGE values in the ASSIGNMENT table. Your query should…

Q: List all customers who were referred to the bookstore by another customer. List each customer's last…

A: The way the question is put up. It is very likely that the question is of SQL language.  Also, you…

Q: SQL Find the guide last name and guide first name of all guides who can lead a paddling trip

A: To merge the data between the tables: guide, trip guide, and trip tables SQL join method is used. It…

Q: • Retrieve the amount and check information for all customer with their name. Also show the…

A: Executable query to find all customer names whose credit balance is less than or equal Query: A…

Q: List the names of those products that have been sold to more than 10 customers. Sort your results by…

A: SQL is also known as Structured Query Language. SQL is a standard language for storing, manipulating…

Q: List the item ID, description, and on-hand value of each item whose number of units on hand is more…

A: Subquery : A subquery is a query that is nested inside a SELECT , INSERT , UPDATE , or DELETE…

Q: In the SQL Oracle Application List all employees who have not changed jobs even once. (Such…

A: DISTINCT : The statement SELECT DISTINCT will return the unique/distinct values from the table, this…

Q: Delete the employee who has the longest employment in the company using sql

A: can be done by sorting the table and then deleting the oldest date row. please see the SQL script in…

Q: SQL "List the item ID, description, and on-hand value (units on hand * unit price) of each item in…

A: select    I.ITEM_ID, I.DESCRIPTION, SUM(I.ONHAND_UNITS * C.ITEM_COST) ON_HAND_VALUE    from    ITEM…

Q: Display the territory ID and the number of salespersons in the territory for all territories that…

A: SQL (Structured Query Language) is designed primarily for managing data in a relational database…

Q: List the owner number, last name and first name of every condo owner.

A: Use a nested query where we are including the condition to include only the OwnerNum which is…

Q: Using SQL find the number of employees from the table:

A: We just need to count all the rows in the given table that will result in the number of employess.

Q: Under what circumstances must you include a GROUP BY clause in a query?

A: “GROUP BY” clause must be included when both aggregate columns such as “SUM()”, “AVG()” and…

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

A: The question is to list student names and total reservations for all students whose have reserved a…

Q: What is the number of seats booked for the family?

A: As per the above information It is clear that the above information is about ticket booking ,This…

Q: List the item ID, description, and category for each pair of items that are in the same category.…

A: ANSWER:-

Q: Display details of employee with ID 150 or 160. using sql

A: To find the details of the employee having ID 150 or 160.   Note:  The detail of the table is given…

Q: Use Employees table to display the department id and highest salary with the column name "Highest…

A: The Answer is

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.