For each passenger listed in the PASSENGER table, display the name of the person responsible for his or her reservation only if the passenger himself or herself was not responsible for making the reservation. How Can I start this query? Can you help me? Thank you!

Q: The query that displays names of employees , sex , and evaluation of the salary for each department…

A: SELECT AVG(salary) /*incorrect*/ FROM EMPLOYEE, DEPENDENT  /* a salary is included once */ WHERE…

Q: Write a SELECT statement that returns the companyname, address, city and postalcode from the…

A: According to your question the supplier is is also present in the product table so the 29 rows are…

Q: --List all products whose unit price is less than the average price. --List the shipper id,…

A: Given: consider the tables as. product { productID, productNAME, price_per_unit, category_product }…

Q: the following Query on the books table from book store database. m Note: the table books consist of…

A: We use the SELECT command for this with WHERE condition on it.

Q: Which query determines the customers who have ordered the most books from JustLee Books?  (refer to…

A: Query The query that determines the customers who have ordered the most books from JustLee Books is…

Q: Write a query which shows the common last names of any individuals in both tables. Make sure you…

A: I have written query in next step.

Q: ​Create a Query with customerID, Name and Address whose address belongs to ‘Ibri’

A: Given: Create a Query with customerID, Name and Address whose address belongs to ‘Ibri’

Q: Add a column named ON_HAND_VALUE to the NONCAT table. The on-hand value is a seven-digit number with…

A: Alter table : used to modify column, add column/columns, add constraints, drop column, rename, drop…

Q: Create a query to produce the summary of the value of products currently in inventory. Note that the…

A: The contents from the table can be viewed by using "SELECT" statement which comes under Data…

Q: Write a query which set the following constraints in Customers table (in MySQL). First Name and…

A: We are going to add constraints to the columns in the table Customers. First we will add constraint…

Q: . Which manufacturers are located in the city of New York? Show the manufacturer's name, state,…

A: First, three parts will be answered. SQL query: 1) In this query, the SELECT statement along with…

Q: SELECT name FROM instructor WHERE name LIKE % dar_ Which of the instructor names will NOT be…

A: The names “Alimdarr” and “Alimdar” will NOT be included in the result of given query.   Hence the…

Q: FROM SALESPERSON WHERE SPNUM= (SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772): What is this subquery…

A: Given subquery SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772

Q: Create a query that will display the Appointment date, the patient information the bill status and…

A: The query using multiple tables is created using the following syntax. SELECT column_name1,…

Q: You are not required to execute the queries. However, your syntax must by accurate.You must give at…

A: Hey, since there are multiple sub-part questions posted, we will answer first three questions. If…

Q: Sql server 2012 query question Make the following queries?…

A: Select Those Hospital whose district is Karachi and Hyderabad                               Select…

Q: create a subquery. (sql)   Query employee name, phone number, job name, salary. In addition, get…

A:

Q: Write the query. 1. Display the last name and salary for all employees whose salary is not in the…

A: SQL CODE TO CREATE NEW AND ADD VALUES: /* Create a table called EMPLOYEE */CREATE TABLE…

Q: the following Query on the books table from book store database. Note: the table books consist of…

A: Let's see step by step: Given Table : books Schema given : (book_name , author , year_of_publication…

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: Write a SELECT statement that returns the companyname, address, city and postalcode from the…

A: Write a SELECT statement that returns the companyname, address, city and postalcode from the…

Q: please use sql to answer the following question and erd had been attach List the customers living…

A: we can use the IN condition in SQL to get the list of orders totalling more than $80 at grouping…

Q: Given the tables below, which query will execute successfully?   Employee (EmpID, name, Gender,…

A: Answer given below :

Q: Create a query that displays each instructor schedule. Display the instructor name, course title,…

A: Actually, the answer has given below:

Q: Write a query to list month and profit for 2008 and sort the list ascending by profit. What month is…

A: Note: You did not mention which SQL we have follow so we did it in MySql     CREATE TABLE Product…

Q: Write a query to display the patron ID, first and last name of all patrons who have never checked…

A: Given Write a query to display the patron ID, first and last name of all patrons who have never…

Q: A subquery must be placed in the outer query's HAVING clause if:     1.The subquery returns more…

A: Sub query is present in the main query or outer query. Sub query also called as inner query. The sub…

Q: Create a query for displaying minimum salary in column alias “Minimum Salary” along with job_id…

A: Format of query :-  SELECT colounname ,  MIN( coloumname) AS aliasname FROM tablename;   According…

Q: Return all of the records and the fields in the customers table. What is the query to return all…

A: According to the answering policy, I can answer only 3 questions for the remaining parts please…

Q: Perform any 2 DML Queries. Show Output: 1. Write SQL Query for finding/displaying names of nurses…

A: Information provided is incomplete. Require table schema. Kindly provide the table details to get…

Q: Salary from highest to lowest  Sorting emp name alphabet

A: Please find the answer below

Q: Write a query to display the book number, title, year of publication, subject, and cost for all…

A: Hi,  We will perform the question implementation in SQL DB language. For that, we will follow the…

Q: Write a query to display the author ID and the number of books written by that author. Sort the…

A: Explanation: The below query displays “AU_ID” and total book numbers from “WRITES” tables using…

Q: Not all Global Fast Foods staff members have a manager. Create a query that displays the employee…

A: To create a query that display the employee last name and 9999 in the manager ID column.

Q: List the balance characteristics of the customers who have made purchases during the current invoice…

A: SELECT  CUS_CODE, CUS_BALANCE FROM  CUSTOMER WHERE  CUSTOMER.CUS_CODE IN     (SELECT DISTINCT…

Q: Create a query for displaying all data of employees who have joined company before 14-JUL-03 OR…

A: Lets see the solution.

Q: Je an expressioi relational aigebra Not on SQL ) V Find the ID and name of each employee who does…

A: Expression in Relational Algebra   a) Project ID, name (SELECT Company_Name <> "BigBank"…

Q: ng the ERD above, formulate queries to satisfy the following questions. Do not include NULL values.:…

A: 1. To print all the lastnames and emails only select statement is enough.   2. Here names of artists…

Q: Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name,…

A:

Q: For each customer who has a post-paid service, show how many of these customers have  opted to have…

A: COUNT(): The COUNT() function calculates the number of items that meet a given set of criteria.…

Q: List the customer ID and first and last names for all customers located in the city of Cody. Your…

A: Convert the city to upper case and then check  whether city is CODY or not

Q: Using HR Schema, write a query to find first name, last name and department ids for employees in…

A: Solution in Step 2.

Q: Create a query that displays each instructor's schedule. Display the instructor name, course title,…

A: Actually, the answer has given below:

Q: Create a query of renters not qualified to rent, list who rented boat unique ID, Renter name, Renter…

A: Actually, SQL is a  structured query language.

Q: ty A ,sala

A: Create a table Employee with attributes id, first and last name, city, salary and increase in…

Q: Create a query for displaying e1.first_name with e1.last_name of employee under column alias…

A: SQL has a built in function called as  CONCAT(VAL1,VAL2,....VAL255) AS Concatenated value.

Q: Write a query to retrieve name of professor, department name and project, for all projects whose…

A: 1.  select professors.name as professorName, departments.name as departmentName, Projects.name as…

Q: 1.Write a query to display the student Id, first name, last name and street of all the students who…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.