List all customers who were referred to the bookstore by another customer. List each customer's last name and the number of the customer who made the referral.

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: 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: List the customer number, customer last name, and customer first name of each customer that lives in…

A: A command to list the customer number, customer last name, and customer first name of each customer…

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: Which month and year (e.g., March 2017) had the greatest number of ER visits? The result table…

A: CREATE TABLE Patient( Patient_Id int[10],gender char[5],age int[5],PRIMARY KEY(Patient_Id));…

Q: Delete the EndDate column from the EMPLOYEES table.

A: Deleting column: The Structured Query Language (SQL) alter statement is used when there is a need…

Q: Find the rep number, last name, and first name of each sales rep who represents at least one…

A: The, answer has given below:

Q: SQL  list all books with theme horror, list bid ( bookid) and total how many time has been reserved…

A: Answer: This is DBMS so that can access table with the help of primary key ass well as foreign key .…

Q: Display employees where the first name or last name starts with S. using sql plus hr user

A: To select data from a database,  SELECT statement are used. The data is saved in a result table…

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: 9. Find the room number with no booking.

A: Introduction: The syntax to write a query in SQL is shown below. SELECT table_columns FROM…

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 customers live in New Jersey?  List each customer's last name, first name, and state. SQL…

A: Note: column names are assumed since table schema is not provided. Query:

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: 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: 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: Write the SQL code required to list the first name and last name of all customers whose middle…

A: Writing the SQL code required to list the first name and last name of all customers whose middle…

Q: Using SQL Show the distinct location_id for all the locations where the company has departments

A: SQL  SQL stands for Structured Query Language, and it is a programming language used to store,…

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: Find out the total sales, minimum sales, maximum sales and the number of invoices during the 2nd…

A: Overview : The COUNT() function returns the number of rows that matches a specified criterion. The…

Q: Mark the Category column of the BOOK_PRICING table as unused. Verify that the column is no longer…

A: Marking the column in a table: In Structured Query Language (SQL), alter statement is used when…

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: Item Number (Item Name) In this case, the date of supply is 04 VENDOR Vendor supply chain Authors'…

A: Attribute (Simple): Simple qualities are ones that cannot be further subdivided. For example, in the…

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: From the above student table, find the students whose status is registered but not postponed using…

A: We are going to find those students whose status is registered but not Postponed. And we are going…

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: 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: 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: 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: Show the employees who were in the engineering department as of Jan. 1, 2005 (using SQL)

A: Given : Show the employees who were in the engineering department as of Jan. 1, 2005 (using SQL)…

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: 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: 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: 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: Show a list of employee id, names, department, years and job of any employee in the staff table who…

A: First you have to make a table called Employee after this you just have to enter random values to…

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: 1 Update CITY_NAME of CUSTOMER table for all customers. Take CITY_NAME from CITY table according to…

A: Update CITY_NAME of CUSTOMER table for all customers. Take CITY_NAME from CITY table according to…

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: 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…

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.