d)' List property location, owner name and maintenance date for property managed by Property Pete. Sort the answer in descending order by property location.

Q: The query should list all employees whose Position begins with the word greenhouse and whose weekly…

A: These question answer is as follows,

Q: List unique first (first_name) and last names (last_name) of customers (CUSTOMER table) who rented a…

A: In this question, we are asked to write a SQL query to fetch the unique first and last names who…

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: Use SQL and TAL Distributors database to complete the following questions: List the item number and…

A: List the item number and description for all items. The descriptions should appear in uppercase…

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: CUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the…

A: Answer:- Atrributes: It is a column in a table Table CUSTOMER: Atrributes : 1.custID( Type),…

Q: List all book titles that have never been borrowed by any borrower.

A: The SQL program for the given problem is as follows: use demo;Create table Book(ISBN varchar(30) Not…

Q: Q6) how much is the total customer balance ? Q7) what is the minimum price for each sale code?

A: SQL QUERY:  Select SUM(CUS_BALANCCE) AS [Sum of Balance] From Customer  Group by CUS_CODE.

Q: List every column in the Condo_UNIT table and its associated typ

A: The, database is a used to stores the data.

Q: Show all name and phone numbers of students and the type of donation they received including any…

A: Show all name and phone numbers of students and the type of donation they received including any…

Q: t the title of all books in the same category as books previously purchased by customer 1007. Don’t…

A: Lets see the solution.

Q: Based on the ERD below, display Employee first name, middle initial and last name so it displays in…

A: In this case, the whole name is displayed in a single column of employees where the job code is…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

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

A: Query:-

Q: Display the RID, RType and Bedroom of all ROOMS whose number of bedrooms is less than RID 105. Use…

A: Required:

Q: Find nth number highest salary. Table:- EMPLOYEE Column Name:- Name,Dept_id,salary,On_Year_Exp.

A: Find nth number highest salary.Table:- EMPLOYEEColumn Name:-Name,Dept_id,salary,On_Year_Exp

Q: Who has rented movies in Japanese language? Return only the first five distinct results in…

A: The INNER JOIN keyword chooses records from both tables whose values match. The SELECT clause just…

Q: Write the following as the MySQL query:  List the employee ID, first name, last name, hire date,…

A: In database administration, it is frequently essential to extract particular data from a dataset…

Q: department name information for those departments whose location_id is 1500

A: Attributes of Department Table are- department_id department_name employee_id location_id

Q: Rank Normal forms where each form is a subset of the form above it. [ Select) [Select First Normal…

A: We are going to arrange Normal forms in the database.

Q: database HR Display the last name, salary, and commission for all employees who earn…

A: /* Creation of EMP table, I am creating column EMP_FIRST_NAME and EMP_LAST_NAME instead of…

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 query "List the title and ISBN of all books using the BOOKS table"

A: Query to display all the records of the books table:   SELECT ISBN, BOOK_TITLE FROM BOOKS;

Q: 9. Find the total amount of tax paid by resident of NJ Hint: The tax cost stored in tax_amount…

A: Inner join is used to join two tables. Tax_amount column is given , to find sum value of a column.…

Q: Select employee first name, concatenate it with job, find length of department id, find location of…

A: Select employee first name, concatenate it with job, find length of department id, find location of…

Q: Orders Table: OrderID,CustomerID, Order Date, TotalAmount Customers Table: CustomerID, CustomerName.…

A: In this question we have to create a query to retrieve the customer name and order date for each…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: List the department name and its instructor’s average salary in which the instructors teach a course…

A: SQL implements WHERE clause with SELECT command in order to retrieve stored information from the…

Q: Display the last_name of students table who have algebra_grades from 80 to 90,

A: i have answered this question in step-2.

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: Display the last name, salary, and commission for all employees who earn commissions. Sort data in…

A: In the above question, needs to find out only those employee's last name, salary, and commission who…

Q: Please explain how to set the mining “difficulty”.

A: The difficulties of mining association rules from large databases: 1. Security and social issues:…

Q: List the trip name, trip id and customer number of all reservations for hiking trips. Sort the…

A: Explanation:  The query displays the trip id, trip name, and start location using the “TRIP” object…

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

A: The answer to the question is given below:

Q: ServiceCategory CategoryNum CategoryDescription 1 Plumbing 2 Heating/Air Conditioning 3 Painting 4…

A: The query to List the location number and unit number for every condo whose square footage is equal…

Q: I. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: To write the SQL query.

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

A: The querry has given

Q: 1. Retrieve the SSN_NUMBER of all employees whose name starts with N. Attribute First Name Last Name…

A: Given: Structure of a table employee is given having attributes First_Name, Last_Name, SSN_Number.…